Deploying the database
When it comes to deploying our database, Entity Framework does a lot for us. We could let Entity Framework apply the migrations if needed, but I am a bit of a control freak.
Entity Framework creates code for both applying and removing the change, so it should be pretty safe to let it do its thing. There is another option, and that is letting Entity Framework generate SQL scripts that we can apply ourselves.
By adding the script
flag, we will get a SQL script we can run against our database:
dotnet ef migrations script 20180904195021_InitialCreate
There are many different databases we can use, such as Microsoft SQL, MySQL, and, as we used in this book, SQLite.
We could also go for a non-relational type of database. Blazor supports it all, so whatever is right for the project is what we should use.