实体框架6迁移可以包括围绕脚本交易？ [英] Can Entity Framework 6 migrations include a transaction around scripts?

问题描述

很简单的问题，我正在使用实体框架6迁移，而像命令

Very simple question, i am using migrations in entity framework 6, and like the command

update-database -script

但有生成脚本的方式，但有它包裹着一个事务？

But is there a way of generating the script but have it wrapped with a transaction?

问题是，如果脚本失败，我要拆散它

Problem is that if the script fails, i have to unpick it

推荐答案

这是我使用的是仅在释放模式怎么生成脚本：

This is what I'm using only on release mode to generate the scripts:

public class MigrationScriptBuilder : SqlServerMigrationSqlGenerator
{
#if !DEBUG
    protected override void Generate(SqlOperation sqlOperation)
    {
        Statement("GO");

        base.Generate(sqlOperation);

        Statement("GO");
    }

    public override IEnumerable<MigrationStatement> Generate(IEnumerable<MigrationOperation> migrationOperations, string providerManifestToken)
    {
        yield return new MigrationStatement {Sql = "BEGIN TRAN"};

        foreach (var migrationStatement in base.Generate(migrationOperations, providerManifestToken))
        {
            yield return migrationStatement;
        }

        yield return new MigrationStatement {Sql = "COMMIT TRAN"};
    }
#endif
}

这篇关于实体框架6迁移可以包括围绕脚本交易？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！