
Explanation

The SQLite provider has a number of migrations limitations. You can workaround some of these 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.
References: https://docs.microsoft.com/en-us/ef/core/providers/sqlite/limitations