Connect to Sqlite database at run time using entity framework

Question

I want to connect my project to an Sqlite database. So, in my Database Context I have this cunstructor and an Initialize method

    private  DatabaseContext(string cnxString) : base(cnxString)
    {
        Database.SetInitializer<DatabaseContext>(new DatabaseInitialiser());
    }
    public static void initialize(string connx)
    {
        _instance = new DatabaseContext(connx);
    }

and In the program.cs I call Inialize method to set the connexion string

DatabaseContext.initialize("data source=D:\storage.sqlite;");

So, every user can connect to his database by passing his connexion string.

But, when running my application I have this error :

An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

I want to connect to my database without app.config, only with c# code — Alkao12
– Alkao12, Commented Oct 25, 2013 at 14:33

bricelam · Accepted Answer · 2013-10-25 16:05:05Z

2

You'll need to pass in a SQLite connection object to the base constructor:

private DatabaseContext(string cnxString)
    : base(new SQLiteConnection(cnxString), contextOwnsConnection: true)
{
}

answered Oct 25, 2013 at 16:05

bricelam

30.7k9 gold badges97 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

Connect to Sqlite database at run time using entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related