如何在C＃中使用TransactionScope？ [英] How do I use TransactionScope in C#?

问题描述

我想使用TransactionScope，但继续得到下面的异常。应用程序运行在不同于数据库的机器上，如果这很重要。

分布式事务管理器（MSDTC）的网络访问已禁用，请在安全配置中启用DTC进行网络访问

 使用（TransactionScope tsTransScope = new TransactionScope（））
 {
 // Do stuff here 
 tsTransScope.Complete（）; 
} 
  

编辑

我根据反馈做了一些Chambes。现在我得到这个错误：

  {错误HRESULT E_FAIL从调用COM组件返回。 
 {与底层事务管理器通信失败。} 
  

解决方案
我认为接受的答案解决了我得到的初始问题。第二个错误似乎是特定于实体框架。

以下是客户端的属性：
有这个有趣的建议：

您需要另一个配置设置
（虽然我认为
它是一个不常见的情况）是
RestrictRemoteClients注册表项。如果
这个键的值设置为2
（RPC_RESTRICT_REMOTE_CLIENT_HIGH）然后
MSDTC网络事务将不会
能正常工作。 MSDTC仅支持
RPC_RESTRICT_REMOTE_CLIENT_NONE
（0）和
RPC_RESTRICT_REMOTE_CLIENT_DEFAULT（1）
值。请参阅
http://www.microsoft.com/ technet / prodtechnol / winxppro / maintain / sp2netwk.mspx＃XSLTsection128121120120
有关
的详细信息RestrictRemoteClients。

最后，尽管不是特定于你的问题，使用 TransactionScope 类的一个非常重要的事情是，它的默认设置是利用可序列化的事务隔离级别。可序列化是最严格的隔离级别，坦率地说，它令人惊讶的是，它被选为默认。如果你不需要这个级别的锁定，我强烈建议在实例化 TransactionScope 时将隔离级别设置为一个限制性较小的选项（ReadCommitted）：

  var scopeOptions = new TransactionOptions（）; 
 scopeOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; 
 scopeOptions.Timeout = TimeSpan.MaxValue; 
 
使用（var scope = new TransactionScope（TransactionScopeOption.Required，
 scopeOptions））
 {
 //您的代码在这里
} 
  

I am trying to use TransactionScope, but keep getting the exception below. The app is running on a different machine than the database, if that matters. I am using Sql Server 2005.

"Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool."

using (TransactionScope tsTransScope = new TransactionScope())
{
    //Do stuff here
    tsTransScope.Complete();
}

Edit

I made some chagnes based on the feedback. Now I'm getting this error:

{"Error HRESULT E_FAIL has been returned from a call to a COM component."}
{"Communication with the underlying transaction manager has failed."}

Solution I think the accepted answer fixed the initial issue I was getting. The 2nd error seems to be specific to entity framework. I'll post another question for it.

Here are the properties on the client: Client http://www.portnine.com/data/images/Misc/client.jpg

Here are the properties on the server:

Server http://www.portnine.com/data/images/Misc/server.jpg

解决方案

You need to enable network DTC access as described in this Microsoft TechNet Article. This change may have to be made on both the database and application servers. Often times DTC is already turned on a database server so I'd look at the application server first.

Here is a screen shot of what we use except for the "Allow Remote Administration" option:

I have not run into the HRESULT E_Fail issue you are now having but this article on XP SP2 and transactions had this interesting suggestion:

Another configuration setting that you need to be aware (although I consider it to be an uncommon scenario) is RestrictRemoteClients registry key. If the value of this key is set to 2 (RPC_RESTRICT_REMOTE_CLIENT_HIGH) then MSDTC network transactions will not be able to work properly. MSDTC supports only RPC_RESTRICT_REMOTE_CLIENT_NONE (0) and RPC_RESTRICT_REMOTE_CLIENT_DEFAULT (1) values. See http://www.microsoft.com/technet/prodtechnol/winxppro/maintain/sp2netwk.mspx#XSLTsection128121120120 for more info on RestrictRemoteClients.

Finally, while not specific to your issue a very important thing to note about using the TransactionScope class is that its default setting is to utilize a Transaction Isolation Level of Serializable. Serializable is the most restrictive of the isolation levels and frankly its surprising that it was chosen as the default. If you do not need this level of locking I would highly recommend setting the isolation level to a less restrictive option (ReadCommitted) when instantiating a TransactionScope:

var scopeOptions = new TransactionOptions();
scopeOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
scopeOptions.Timeout = TimeSpan.MaxValue;

using (var scope = new TransactionScope(TransactionScopeOption.Required,
    scopeOptions))
{
    // your code here
}

这篇关于如何在C＃中使用TransactionScope？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！