Best way to create .db

[DjGrego]

Hello. I'm creating a Blazor app with Sqlite/EF Core database. On initial startup, the app will ask for a "Data Path". The app will then create the needed data directories including the database path and file.

All of instructions I see for SQLite/EF Core show the creation of the .db file using a migration command. What would be the best way to create this .db in the Data Path? Should the app copy over a pre-migrated .db file when the Data Path is created or is there a way to do a Initial Migrate inside the program and not by manual command?

Thank you.

 

[Skydiver]

I assume that you are targeting Blazor Server-SIde, rather than Blazor WASM, but please confirm.

 

[DjGrego]

I assume that you are targeting Blazor Server-SIde, rather than Blazor WASM, but please confirm.

Yes. Blazor Server - .NET 8

 

[cjard]

or is there a way to do a Initial Migrate inside the program

Invoke the context.Database.Migrate() method as part of your application startup

 

[Simple Samples]

The Engineering Manager for .NET Data and Entity Framework at Microsoft says they recommend that database migration happen as part of application deployment, rather than first run.

Concurrently running migrations - where is locking? · Issue #9736 · dotnet/efcore