Explanation
E: Run dotnet ef migrations add InitialCreate to scaffold a migration and create the initial set of tables for the
model.
C: You can workaround some of the SQLite limitations by manually writing code in your migrations to
perform a table rebuild. A table rebuild involves renaming the existing table, creating a new table, copying
data to the new table, and dropping the old table.
D: SQLite does not support all migrations (schema changes) due to limitations in SQLite. For new
development, consider dropping the database and creating a new one rather than using migrations when your
model changes.
References:
https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite
https://docs.microsoft.com/en-us/ef/core/providers/sqlite/limitations