Consolidating EF migrations into new InitialCreate

Solution 1:

Consider reading this nice article from Rick Strahl : https://weblog.west-wind.com/posts/2016/jan/13/resetting-entity-framework-migrations-to-a-clean-slate

Basically the solution is not trivial and needs more than just reseting all the migrations into one because you have two scenarios that needs to fit in ONE migration class:

• Create a new database => the migration class should contain every table creation
• My database is already up to date => I need an empty migration class

Solution: The idea of this process is basically this: The database and the EF schema are up to date and just the way you want it, so we are going to remove the existing migrations and create a new initial migration.

In summary, the steps to do this are:

• Remove the _MigrationHistory table from the Database
• Remove the individual migration files in your project's Migrations folder
• Enable-Migrations in Package Manager Console
• Add-migration Initial in PMC
• Comment out the code inside of the Up method in the Initial Migration
• Update-database in PMC (does nothing but creates Migration Entry) Remove comments in the Initial method You've now essentially reset the schema to the latest version.
• once the commented out migration has been executed on the desired database, uncomment the migration code

Solution 2:

If you're not concerned with keeping this migrations, what I've done is delete everything in your migrations folder, and then target a new database in the connection string (or pass in a new one). After that, you can just run the add-migration command:

add-migration InitialCreate

And it should create the migration for you.