ef-migrations

To create EF Core migrations, run dotnet ef migrations add <Name> targeting your infrastructure project and a dedicated startup project, then apply schema changes using dotnet ef database update locally or in production.

A dedicated migrations project prevents DLL locking during development and streamlines production deployments by isolating migration execution from the main infrastructure project.

Yes, you can perform data migrations by inserting SQL statements directly into the Up method of your EF Core migration to transform data alongside schema evolution.

You need to generate a new EF Core migration when adding, modifying, or removing entity properties, changing column types, renaming columns, or making any database schema change.

Yes, the workflow supports applying migrations to both local development and production databases using the dotnet ef database update command across your multi-project setup.