EF 4.1 Code First - 在事务中包装对 SaveChanges 的多个调用

发布于 2024-11-06 15:44:37 字数 528 浏览 6 评论 0原文

出于所述原因此处我需要多次调用 SaveChanges。我希望这两个调用都包含在一个事务中（这样，如果第二个调用失败，第一个调用将回滚）。例如：

AccountsContext context = new AccountsContext(connectionString);

CountryNotes notes = new CountryNotes();
notes.Notes = "First save";
context.SaveChanges();

notes.Notes = "Second save";
context.SaveChanges();

如何将对 SaveChanges 的上述两次调用放入单个事务中？

谢谢，

保罗。

原文

For reasons described here I need to make multiple calls to SaveChanges. I would like both of these calls to be wrapped up in a transaction (so that if the second call fails, the first call will roll back). For example:

AccountsContext context = new AccountsContext(connectionString);

CountryNotes notes = new CountryNotes();
notes.Notes = "First save";
context.SaveChanges();

notes.Notes = "Second save";
context.SaveChanges();

How do I put the above two calls to SaveChanges in a single transaction?

Thanks,

Paul.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

◇流星雨 2024-11-13 15:44:37

使用TransactionScope：

using (var scope = new TransactionScope(TransactionScopeOption.Required, 
    new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }))
{
    AccountsContext context = new AccountsContext(connectionString);

    CountryNotes notes = new CountryNotes();
    notes.Notes = "First save";
    context.SaveChanges();

    notes.Notes = "Second save";
    context.SaveChanges();

    scope.Complete();
}

Use TransactionScope:

using (var scope = new TransactionScope(TransactionScopeOption.Required, 
    new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted }))
{
    AccountsContext context = new AccountsContext(connectionString);

    CountryNotes notes = new CountryNotes();
    notes.Notes = "First save";
    context.SaveChanges();

    notes.Notes = "Second save";
    context.SaveChanges();

    scope.Complete();
}

回复收藏 0 原文

~没有更多了~