Create Database on Runtime - Entity FrameWork Code-First

Question

I have a project which saves its output results into an SQLite database. in every run, the user should select the saving location which the program will create a database there and will save the result inside. so the database's name and location are dynamic.

How can I manage such a thing using entity framework core code first? I have create the models and the DbContext class, but I do not know how to create the database and tables on runtime and so on.

Modify the connection string appropriately and call EnsureCreated? — Caius Jard
– Caius Jard, Commented Apr 18, 2022 at 7:27
Context.Database.EnsureCreated(); will create a database if not created — Ibram Reda
– Ibram Reda, Commented Apr 18, 2022 at 7:48
yeah I know but it gives this error: You need to call SQLitePCL.raw.SetProvider(). If you are using a bundle package, this is done by calling SQLitePCL.Batteries.Init().' — Inside Man
– Inside Man, Commented Apr 18, 2022 at 7:56
Micrsofot docs: Don't call EnsureCreated() before Migrate(). EnsureCreated() bypasses Migrations to create the schema, which causes Migrate() to fail — Okan Karadag
– Okan Karadag, Commented Apr 18, 2022 at 13:10

Inside Man · Accepted Answer · 2022-04-20 10:34:05Z

1

I have found the solution, I should use raw.SetProvider(new SQLite3Provider_e_sqlite3()); in OnConfiguring:

public MyDataContext(string path, bool create = true)
{
    FilePath = path;
    if (create)
    {
        Database.EnsureDeleted();
        Database.EnsureCreated();
    }
}

protected override void OnConfiguring(DbContextOptionsBuilder optionbuilder)
{
    optionbuilder.UseSqlite($"Data Source={FilePath}");
    raw.SetProvider(new SQLite3Provider_e_sqlite3());
}

answered Apr 20, 2022 at 10:34

Inside Man

4,21912 gold badges69 silver badges142 bronze badges

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

Collectives™ on Stack Overflow

Create Database on Runtime - Entity FrameWork Code-First

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