Merge migrations in entity-framework-core

asp.net-core c# entity-framework entity-framework-core

Question

Is it possible to merge all migrations files into one ?

I created initial migration.

dotnet ef migrations add InitialMigration

Source

When ever I have some model change I create new migration update.

But now I have too many migration update files. Is ti possible to merge all migration files to one ?

Off course drop database is not an option, I have to preserve data !

1
17
11/22/2016 4:44:12 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

EF 6.X has a option IgnoreChanges. That is the perfect fit for your scenario. But unfortunately it is not a feature available in EF core.

But there is a workaround.

Step 1 : Delete all the migration scripts in the Migrations folder.

Step 2 : In the package manager console : run

PM> Add-Migration InitialCreate

Step 3 : Delete both Up() and Down() methods code. Before you do this, keep those methods saved elsewhere as we will need them again in step 5.

Step 4 : run:

 PM> Update-Database

It'll insert a new record into __EFMigrationsHistory table.

Step 5 : After that fill the above migration script's (i.e. .._InitialCreate) Up() and Down() method from the content kept in a safe place from Step 3.

That is it. Now you have only 1 migration file :)

Note : EF core with Package manager console (PM) :Package Manager Console

26
7/17/2018 12:44:03 PM

Popular Answer

One way to do that is removing all migration files physically and adding new one. If your migrations are in "Migrations" folder, you can simply delete it, otherwise you need to delete your "ModelSnapshot" file too. I think this approach can solve your issue.

kizilsu

Related Questions

Merging migration entries in Entity Framework

I have an Entity Framework 6 CF project that has a few migrations already in place....The model is now stable and there is no need to keep the migration history that already exists....Is there a way to reset the model and merge all migration commands into the initial migration?...As an example, the first migration adds a column while the second mig...
.net c# ef-migrations entity-framework entity-framework-6
asked by Raheel Khan

Entity Framework Core Migration for ASP.Net Core Class Library

UPDATE:... And now this answer appears to be out of date! Turns out 1.1 has removed this feature. After upgrade to 1.1 it no longer works. Odd that this would stop working. Setting up the class library to work like a console application as Ben Cull suggests appears to be the way to handle it when using EF Core 1.1...That blog article is pretty ...
asp.net-core-mvc entity-framework-core
asked by Dave van Herten

Entity Framework Core - REST json merge patch (Partial Update)

EF Core supports Json Patch - ...RFC6902...https://github.com/aspnet/JsonPatch...I wanted to add support for Json Merge Patch in my app - ...RFC7396...I am new to entity framework....I tried following, it works fine, but wanted to know if the implementation is alright (model validation being handled in a filter, so please ignore that part):...[Http...
c# entity-framework entity-framework-core rest
asked by adnan kamili

Entity Framework Core 2.0 Add-Migration doesn't create any migration files

I had to mark a project as the start-up project.
c# database-migration ef-migrations entity-framework entity-framework-core
asked by Frank Horemans

Incorrect syntax near 'MERGE' Entity Framework Core

I have a problem when try to create a client, who has a few addresses....public class Client { public int Id { get; set; } public string Name{ get; set; } public string Lastname{ get; set; } public int DNI { get; set; } public List<Phones> Phones{ get; set; } } public class Phone { [Key] public int IdPhone { get; set; }...
asp.net-core c# entity-framework-core
asked by PCH

Entity framework core, code first migration with data migration

I am trying to use EF Core code first migrations to de-normalise an existing table....I have en existing table ...LoginEvent... which data looks like this:...╔═════════════════════════════════════════════════╗ ║ LoginEvent ...
c# ef-migrations entity-framework-core
asked by Kram

Add migration - Both Entity Framework Core and Entity Framework 6 are installed

I have a solution with multiple projects one of them with EF 6 and another one with entityframeworkcore....The migrations were working fine before adding EF6 project, but now I can't use the migration's command : ...add-migration 'anything'...Both Entity Framework Core and Entity Framework 6 are installed. The Entity Framework Core tools are runnin...
c# ef-migrations entity-framework entity-framework-core visual-studio-2017
asked by Shahrukh Ahmad

Entity Framework Core: create a migration that merges multiple DbContexts (with multiple migrations)

When I started a project (an Identity Server 4 server) I created an ApplicationDBContext (which inherits from ASP.NET IdentityContext and hassome custom tables) and used the ConfigurationDBContext as well as the PersistedGrantDBContext from Identity Server 4. I created 3 migrations (one for each DBContext). Though the data is in the same database (...
c# entity-framework-core entity-framework-core-2.2 entity-framework-core-migrations identityserver4
asked by monty

Entity Framework Core 3.1 merge IdentityDbContext with myDbContext

I want to merge default identity ...DbContext... with other tables (my own ...DbContext...); I reverse engineered the identity ...DbContext...: it provides model classes (some models are partial) and a ...DbContext...:...namespace pakshavad.Data { public partial class aspnetpakshavadContext : DbContext { public aspnetpakshavadContex...
asp.net-core asp.net-identity c# entity-framework-core
asked by sda2584541

ASP.NET Core + Entity Framework Core + SQLite Creating initial migration throws error

I am doing a ASP.NET Core beginner tutorial on Udemy. The task is to create a Code First SQLite database and I want to create a Initial migration which is failing. Below I describe the steps I have made....I have installed the packages ...Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.Design Microsoft.EntityFrameworkCore.SQLite ...The ...
asp.net-core ef-migrations entity-framework-core sqlite
asked by canvee

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