How to apply migrations from code (EF Core)

Question

Here is some working EF6 migration code:

Database.SetInitializer<CmContext>(null);
var settings = new MigrationsConfiguration();
var migrator = new DbMigrator(settings);
migrator.Update();

What is the equivalent using EF Core?

ErikEJ · Answer 1 · 2015-11-17T19:24:37.053

20

In beta 7 and on, use:

using Microsoft.Data.Entity;

...

context.Database.Migrate();

edited Nov 17 '15 at 19:24

answered Jul 29 '15 at 20:27

ErikEJ

40,951
5
75
115

This seems to be changed in beta7? looking for some info about how to migrate beta6 to beta7, ApplyMigrations isn't there anymore, ContextType attribute seems to have gone.. or my project just have gone haywire.. again. ;) – neslekkiM Sep 16 '15 at 13:21
Start over - much have changed! – ErikEJ Sep 16 '15 at 13:57
where do you put this code? Seems initializers and the like have changed so much I don't know where this would go. – Trevor de Koekkoek Sep 30 '15 at 13:27
In your application startup code, only to be run once – ErikEJ Sep 30 '15 at 17:41
`Migrate` is an extension, so you have to `using Microsoft.Data.Entity;`. – Scott Stafford Nov 17 '15 at 18:38
@ErikEJ, where would be a good place to call it at your ASP.NET Core app entry point that DI is ready? – Shimmy Weitzhandler Jul 03 '19 at 07:06
1

@shimmy https://blog.rsuter.com/automatically-migrate-your-entity-framework-core-managed-database-on-asp-net-core-application-start/ – ErikEJ Jul 03 '19 at 16:00
@ErikEJ, the kind of answer I was after. Thank you! – Shimmy Weitzhandler Jul 03 '19 at 22:37

score 16 · Answer 2 · answered Aug 26 '16 at 11:57

16

For Entity Framework Core 1.0.0, ensure you have the Microsoft.EntityFrameworkCore.Relational NuGet package. Then import this namespace:

using Microsoft.EntityFrameworkCore;

Finally, get hold of a DbContext and run:

context.Database.Migrate();

answered Aug 26 '16 at 11:57

Edward Brey

40,302
20
199
253

Will `context.Database.Migrate()` creates a tables or else will create only Database? – Mdumanoj May 07 '18 at 15:21
Migration creates all schema elements, including tables. – Edward Brey May 07 '18 at 18:46
5

For me its creating only Database, there is no tables in the Database. I have this line of code in `startup.cs` and I am running `Add-Migration` command – Mdumanoj May 08 '18 at 06:36

score 2 · Answer 3 · answered Jun 24 '20 at 08:59

According to the Microsoft documentation, for more advanced scenarios than simply applying the migrations which are already present in your project file structure, you can use the EF Core IMigrator service. You can easily access the internal implementation by utilizing the following access code:

var migrator = myDbContext.GetInfrastructure().GetService<IMigrator>();

How to apply migrations from code (EF Core)

3 Answers3

Linked