Entity Framework Core 2.0 - 逐步运行迁移 [英] Entity Framework Core 2.0 - Run migrations step by step

问题描述

在 EF6 中，我可以检索迁移并​​逐步运行它.
有没有办法在 EF Core 中做类似的事情?

In EF6 I could retrieve migrations and run it step by step.
Is there a way to do something similar in EF Core?

EF 6 代码

public static void RunMigration(this DbContext context, DbMigration migration, string providerName, string manifest)
{
    var prop = migration.GetType().GetProperty("Operations", BindingFlags.NonPublic | BindingFlags.Instance);
    if (prop != null)
    {
        IEnumerable<MigrationOperation> operations = prop.GetValue(migration) as IEnumerable<MigrationOperation>;
        MigrationSqlGenerator generator = (new DbMigrationsConfiguration()).GetSqlGenerator(providerName);
        var statements = generator.Generate(operations, manifest);
        foreach (MigrationStatement item in statements)
            context.Database.ExecuteSqlCommand(item.Sql);
    }
}

推荐答案

您可以使用 GetPendingMigrations 类的扩展方法(由database 的code> 属性返回>) 获取待处理的迁移名称列表.

You can use the GetPendingMigrations extension method of the DatabaseFacade class (returned by Database property of the DbContext) to get the list of the pending migration names.

然后就可以获取IMigrator 服务并使用 Migrate 方法传递每个目标迁移名称:

Then you can obtain IMigrator service and use Migrate method passing each target migration name:

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Migrations;

DbContext db = ...;
var pendingMigrations = db.Database.GetPendingMigrations().ToList();
if (pendingMigrations.Any())
{
    var migrator = db.Database.GetService<IMigrator>();
    foreach (var targetMigration in pendingMigrations)
        migrator.Migrate(targetMigration);
}

这篇关于Entity Framework Core 2.0 - 逐步运行迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！