After performing a migrations scaffold with the .NET CLI for EF migrations, there is a continual error in the terminal output where the SQLite extension already sees an existing table with the same name that was passed to the dotnet ef database update command.
Whenever the database attempts to be created, the following console output keeps occurring:
SQLite Error 1: "table 'table_name' already exists."
DbCommand Failure: SQLite Err #1
Attempts to resolve:
- Reverting to previous migrations before rebuilding database with
dotnet ef database updatecommand. - Adding "0" flag to revert to previous migration instance with
dotnet ef database update 0command. - Removing scaffold with
dotnet ef migrations removecommand. - Rebuilding with
dotnet ef migrations add -ocommand for appropriate current working directory. - Reinstalling dotnet ef framework.
Also, reference to this following author on StackOverflow did not apply for this particular issue:
How to fix an SQLite Error 1 in a C# .NET Entity Framework Core Model?
The "hoped for" outcome for reverting or rebuilding is for a clean migrations scaffold in case that may be the cause for duplication.
Also, not sure if related, but null references have been "disabled" in the API file that .NET requires for this project.