Entity Framework 6迁移可以包括一个关于脚本的事务吗? [英] Can Entity Framework 6 migrations include a transaction around scripts?
本文介绍了Entity Framework 6迁移可以包括一个关于脚本的事务吗?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
非常简单的问题,我在实体框架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
}
您的 DatabaseMigrationsConfiguration
。示例:
public sealed class DatabaseMigrationsConfiguration : DbMigrationsConfiguration<DatabaseContext>
{
public DatabaseMigrationsConfiguration()
{
SetSqlGenerator("System.Data.SqlClient", new MigrationScriptBuilder());
}
}
这篇关于Entity Framework 6迁移可以包括一个关于脚本的事务吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文