Setting the password by code to a Sqlite2 database on Entity Framework 6

Question

Using: Visual Studio Community 2015 + C# + Entity Framework 6.2 + SQlite2

I know how to protect a SQlite database as I use the below code to attach password to it :

using (sqlite2 = new SQLiteConnection("Data Source=ModuleUserDB.db"))
{
    //Set password
    sqlite2.SetPassword("this is my password");
}

But this doesn't work with Entity Framework.

I read this post How to in-code supply the password to a connection string in an ADO.Net Entity Data Model

but I can't figure out the solution for my case

DbContext name: ModuleUserDBEntities
Database name: ModuleUserDB.db

Trying to modify the constructor with:

public partial class ModuleUserDBEntities : DbContext
{
    public ModuleUserDBEntities() : base("name=ModuleUserDBEntities")
    {
        // Set the password of the database
        this.Database.Connection.ConnectionString = @"Data Source=.\;Initial Catalog=ModuleUserDB.db;Persist Security Info=True;User ID=sa;Password=myownpassword";
    }
}

But Visual Studio gets stuck.

What is the simplest connection string to use for this case?

According to this there is no username in the connection string. And please use a better problem description than "Visual Studio gets stucks". If there is an exception provide the entire exception detail. — Crowcoder
– Crowcoder, Commented Apr 15, 2018 at 15:46
@Crowcoder Just Visual Studio gets stucks with this info on the Inmediate Window: Step into: Stepping over non-user code 'WpfApplication1.App..ctor' Step into: Stepping over non-user code 'WpfApplication1.App.InitializeComponent' — fedeteka
– fedeteka, Commented Apr 15, 2018 at 15:59

Aousaf Rashid · Accepted Answer · 2018-04-15 15:53:22Z

2

Give ChangePassword method a try.Sample :

   using (sqlite2 = new SQLiteConnection("Data Source=ModuleUserDB.db"))
   {
    sqlite2.Open();  //You must open the connection first
    sqlite2.ChangePassword("password here"); 
   }

edited Apr 15, 2018 at 15:53

answered Apr 15, 2018 at 15:40

Aousaf Rashid

5,7986 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Crowcoder Over a year ago

How does changing the password resolve the connection string issue? Also you code has errors.

Aousaf Rashid Over a year ago

ChangePassword method changes password if there's an existing password, if there isn't,it sets the password :)

Crowcoder Over a year ago

Yeah but how will that help Entity Framework connect?

Aousaf Rashid Over a year ago

My answer answer only How to set password for sqlite , isn't that what OP is asking for ?

Crowcoder Over a year ago

That's not the way I read it. OP says "I know how to protect a SQlite database..."

|

Collectives™ on Stack Overflow

Setting the password by code to a Sqlite2 database on Entity Framework 6

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related