如何在实体框架中配置事务？

发布于 2024-10-27 18:43:29 字数 154 浏览 2 评论 0原文

如何在 Entity Framework 4 中配置事务？在普通的旧 Ado.Net 中，我们有一个名为 SqlTransaction 的类，我们还可以为该事务指定隔离级别，如 Read_Commited、Read_UnCommited 等。我在实体框架中找不到所有这些选项。我们如何配置它们？

原文

分享到QQ

分享到微博

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

发布评论

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

忆梦 2024-11-03 18:43:29

您可以使用 TransactionScope 类，并设置隔离使用 TransactionOptions 的级别，如此处：

TransactionScope 的一些重载构造函数接受 TransactionOptions 类型的结构来指定隔离级别以及超时值。默认情况下，事务执行时隔离级别设置为可序列化。选择 Serialized 以外的隔离级别通常用于读密集型系统。这需要对事务处理理论和事务本身的语义、涉及的并发问题以及对系统一致性的影响有深入的了解。

例如：

using (var context = new EFTestEntities())
{
    context.AddToProducts(new Product { Name = "Widget" });
    context.AddToProducts(new Product { Name = "Chotchky" });

    TransactionOptions options = new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted, Timeout = TransactionManager.DefaultTimeout };

    using (var scope = new TransactionScope(TransactionScopeOption.RequiresNew, options))
    {
        // do any EF work that you want to be performed in the transaction
        context.SaveChanges();

        // commit the transaction
        scope.Complete(); 
    }
}

You can use the TransactionScope class, and set the isolation level using TransactionOptions as described here:

Some of the overloaded constructors of TransactionScope accept a structure of type TransactionOptions to specify an isolation level, in addition to a timeout value. By default, the transaction executes with isolation level set to Serializable. Selecting an isolation level other than Serializable is commonly used for read-intensive systems. This requires a solid understanding of transaction processing theory and the semantics of the transaction itself, the concurrency issues involved, and the consequences for system consistency.

For example:

using (var context = new EFTestEntities())
{
    context.AddToProducts(new Product { Name = "Widget" });
    context.AddToProducts(new Product { Name = "Chotchky" });

    TransactionOptions options = new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted, Timeout = TransactionManager.DefaultTimeout };

    using (var scope = new TransactionScope(TransactionScopeOption.RequiresNew, options))
    {
        // do any EF work that you want to be performed in the transaction
        context.SaveChanges();

        // commit the transaction
        scope.Complete(); 
    }
}

回复收藏 0 原文

~没有更多了~