为什么 TransactionScope 不能与实体框架一起使用？

发布于 2024-07-18 00:03:16 字数 1613 浏览 5 评论 0原文

请参阅下面的代码。如果我初始化多个实体上下文，则仅在第二组代码上出现以下异常。如果我注释掉第二组它就有效。

{“底层提供程序在打开时失败。”}
内部：{“与底层事务管理器的通信失败。”}
内部：{“调用 COM 组件已返回错误 HRESULT E_FAIL。”}

请注意，这是一个示例应用程序，我知道连续创建 2 个上下文是没有意义的。但是，生产代码确实有理由在同一个 TransactionScope 中创建多个上下文，并且这是无法更改的。

编辑

这是我之前尝试设置 MS-DTC 的问题。它似乎在服务器和客户端上均启用。我不确定它是否设置正确。另请注意，我尝试执行此操作的原因之一是 TransactionScope 中的现有代码使用 ADO.NET 和 Linq 2 Sql...我希望它们也使用相同的事务。（这可能听起来很疯狂，但如果可能的话我需要让它发挥作用）。

如何在 C# 中使用 TransactionScope？

解决方案

Windows 防火墙阻止与 MS-DTC 的连接。

using(TransactionScope ts = new System.Transactions.TransactionScope())
        {
                using (DatabaseEntityModel o = new DatabaseEntityModel())
                {
                    var v = (from s in o.Advertiser select s).First();
                    v.AcceptableLength = 1;
                    o.SaveChanges();
                }

                //-> By commenting out this section, it works
                using (DatabaseEntityModel o = new DatabaseEntityModel())
                {
                    //Exception on this next line
                    var v = (from s1 in o.Advertiser select s1).First();                         v.AcceptableLength = 1;
                    o.SaveChanges();
                }
                //->

                ts.Complete();
        }

原文

See the code below. If I initialize more than one entity context, then I get the following exception on the 2nd set of code only. If I comment out the second set it works.

{"The underlying provider failed on Open."}
Inner: {"Communication with the underlying transaction manager has failed."}
Inner: {"Error HRESULT E_FAIL has been returned from a call to a COM component."}

Note that this is a sample app and I know it doesn't make sense to create 2 contexts in a row. However, the production code does have reason to create multiple contexts in the same TransactionScope, and this cannot be changed.

Edit

Here is a previous question of me trying to set up MS-DTC. It seems to be enabled on both the server and the client. I'm not sure if it is set up correctly. Also note that one of the reasons I am trying to do this, is that existing code within the TransactionScope uses ADO.NET and Linq 2 Sql... I would like those to use the same transaction also. (That probably sounds crazy, but I need to make it work if possible).

How do I use TransactionScope in C#?

Solution

Windows Firewall was blocking the connections to MS-DTC.

using(TransactionScope ts = new System.Transactions.TransactionScope())
        {
                using (DatabaseEntityModel o = new DatabaseEntityModel())
                {
                    var v = (from s in o.Advertiser select s).First();
                    v.AcceptableLength = 1;
                    o.SaveChanges();
                }

                //-> By commenting out this section, it works
                using (DatabaseEntityModel o = new DatabaseEntityModel())
                {
                    //Exception on this next line
                    var v = (from s1 in o.Advertiser select s1).First();                         v.AcceptableLength = 1;
                    o.SaveChanges();
                }
                //->

                ts.Complete();
        }

分享到QQ

分享到微博

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

发布评论

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

老街孤人 2024-07-25 00:03:16

您的 MS-DTC（分布式事务协调器）由于某种原因无法正常工作。 MS-DTC 用于协调跨多个异构资源（包括多个 SQL 连接）的事务结果。

查看此链接< /a> 了解有关正在发生的事情的更多信息。

基本上，如果您确保 MS-DTC 正在运行并正常工作，那么使用 2 个 ADO.NET 连接应该不会有任何问题 - 无论它们是实体框架连接还是任何其他类型。

回复收藏 0 原文

御守 2024-07-25 00:03:16

您可以通过管理自己的 EntityConnection 并将此 EntityConnection 传递给您的 ObjectContext 来避免使用分布式事务。否则请检查这些。

http://forums.microsoft.com/MSDN /ShowPost.aspx?PostID=580828&SiteID=1&mode=1
http://forums.microsoft.com/msdn/showpost.aspx?postid=113669&siteid=1&sb=0&d=1&at=7&ft=11&tf =0&pageid=1

EntityConnection conn = new EntityConnection(ConnectionString);

using (TransactionScope ts = new TransactionScope())
{
    using (DatabaseEntityModel o = new DatabaseEntityModel(conn))
    {
            var v = (from s in o.Advertiser select s).First();
            v.AcceptableLength = 1;
    }

    //-> By commenting out this section, it works
    using (DatabaseEntityModel o = new DatabaseEntityModel(conn))
    {
        //Exception on this next line
        var v = (from s1 in o.Advertiser select s1).First();
                v.AcceptableLength = 1;
    }
    //->

    ts.Complete();
}

You can avoid using a distributed transaction by managing your own EntityConnection and passing this EntityConnection to your ObjectContext. Otherwise check out these.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=580828&SiteID=1&mode=1
http://forums.microsoft.com/msdn/showpost.aspx?postid=113669&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1

EntityConnection conn = new EntityConnection(ConnectionString);

using (TransactionScope ts = new TransactionScope())
{
    using (DatabaseEntityModel o = new DatabaseEntityModel(conn))
    {
            var v = (from s in o.Advertiser select s).First();
            v.AcceptableLength = 1;
    }

    //-> By commenting out this section, it works
    using (DatabaseEntityModel o = new DatabaseEntityModel(conn))
    {
        //Exception on this next line
        var v = (from s1 in o.Advertiser select s1).First();
                v.AcceptableLength = 1;
    }
    //->

    ts.Complete();
}

回复收藏 0 原文