EF Core Migrations - how to modify the previous migrations?

ef-core-2.0 ef-core-2.1 ef-core-2.2 ef-migrations entity-framework-core

Question

I have a question about editing migration files in EF Core.

Example: I have created 3 tables using separate migration for each: AddTable1, AddTable2, AddTable3.

After that several days later I decided to change the type of status column in Table1 to be int and not string.

After updating the AddTable1 migration file, deleting the database and executing update-database command the column was still defined with string type.

I noticed that all the .Designer.cs files still were using string type for status column despite my edit of Table1 migration file.

I copied the content of the AppDbContextModelSnapshot.cs file and manually updated all the .Designer.cs files for all migrations (note: the method name in source and .Designer.cs files is different).

And that helped. I'm sure that this is not the recommended way to use migrations.

My question is: is there a command which will do what I did - 'reset' the '.Designer.cs' files?

If not, how to make one? :)

1
0
7/10/2019 7:00:13 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Think of migrations as Git commits. You don't rewrite previous commits once you've shared them with other team members (or in our case, applied a migration to a database). Instead, you create new migrations with additional changes.

If you haven't applied a migration or shared it with teammates, you can remove it and re-scaffold:

Remove-Migration
Add-Migration FixedUpMigration

See the EF Core Migrations docs for basic usage.

1
7/10/2019 9:09:51 PM

Related Questions

How to do data migrations inside an EF Core code first migration?

The scenario doesn't fall within the capability of migrations for EF Core 1.0.0. The ...MigrationBuilder... API is designed to build SQL for transforming database schema, and isn't designed for working with multiple databases....You can inspect the implementation of migrations for yourself in EF Core's source code at ...https://github.com/aspnet/En...
c# entity-framework entity-framework-core
asked by natemcmaster

.net core ef migration testing - apply migrations using c# method

Get your context and call...context.Database.Migrate();
.net-core ef-migrations entity-framework-core
asked by Dmitry

Can I inject dependency into migration (using EF-Core code-first migrations)?

you cannot, the migrations need to be able to run outside the context of your application. ...Since the Entity-framework command-line tool analyzes your code but does not run the startup.cs class....Also it is not advisable. your migrations should be plain simple and not depend on anything. if it would, it could lead to major runtime side-effects w...
asp.net-core dependency-injection ef-migrations entity-framework entity-framework-core
asked by Joel Harkes

EF Core Migration Error "Could not drop constraint" which was removed in previous migration

It looks like you may be hitting issue ...#7535.... This will be fixed in version 2.0.0.
c# entity-framework-core
asked by bricelam

Does EF Core migrations call Startup.Configure() on add-migration

Startup.Configure()... should only contain code to configure the request pipeline. Any app startup/initialization code should go in ...Program.Main()....
entity-framework entity-framework-core
asked by bricelam

ASP.net core 2.0 MVC every new database migrations includes data from previous migrations

Another alternative is to make sure the mappings are correct and just delete the up/down functions to have a clean state:...https://github.com/aspnet/EntityFrameworkCore/issues/11763
asp.net-core c# database entity-framework-core
asked by user6728767

dotnet ef migration list not finding migrations in Migration folder

Here is what I did to get migrations working. ...I had to ...also... convert the generated migration files to F#. ...This blog post... by Ody Mbegbu was very helpful here. (Although some modifications have to be made to account for changes since v1.)...I had to add the newly converted .fs migration files to the fsproj.
.net .net-core entity-framework-core f#
asked by CZupnick

Deleted database & migration file, can't make new migrations nor revert old migrations, what now?

If you dropped the database then it's easy. Delete the migrations folder....Then run...add-migration Initial...update-database...Also, I tend to remove any ...<Compile Remove="" />... from the project file.
asp.net-core entity-framework-core entity-framework-core-3.0
asked by Dennis1679

EF Core "no migrations found" despite Migrations folder containing migration files

It turns out this error was because of the lack of Designer.cs files. We deleted them due to ...the response in this post..., but EF was not able to find our migrations without them. If you plan on running your migrations in any other environments, don't delete your Designer files!
.net c# entity-framework-core
asked by emilyw26

EF Core Migrations: Remove Migrations and Re-Sync Database

As I understood, your migrations are not in sync with your database, because someone was changing the database directly. ...You can regenerate your models, DB context and entity configurations from an existing database. Investigate ...Entity Framework Database First .Net Core...If that is the case, you can delete all the migrations (whole ...Migrat...
c# entity-framework entity-framework-core
asked by Vladimir

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow