很简单的问题,我正在使用实体框架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
}