如何在 C# 中使用 TransactionScope?

问题描述

我正在尝试使用 TransactionScope，但不断收到以下异常.
如果重要的话，该应用程序运行在与数据库不同的机器上.我使用的是 SQL Server 2005.

分布式事务管理器 (MSDTC) 的网络访问已被禁用.请在安全配置中为网络访问启用 DTCMSDTC 使用组件服务管理工具.

using (TransactionScope tsTransScope = new TransactionScope()){//在这里做事tsTransScope.Complete();}

编辑

我根据反馈做了一些更改.现在我收到此错误:

调用 COM 组件时返回了错误 HRESULT E_FAIL."
与底层事务管理器的通信失败."

解决方案我认为接受的答案解决了我遇到的最初问题.第二个错误似乎特定于实体框架.我会为此发布另一个问题.

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

另一个配置设置需要注意(虽然我认为这是一个不常见的情况)是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有关更多信息限制远程客户端.

最后，虽然不是特定于您的问题，但使用 TransactionScope 类时需要注意的一个非常重要的事情是它的默认设置是使用 可序列化的事务隔离级别.Serializable 是限制性最强的隔离级别，坦率地说，它被选为默认级别令人惊讶.如果您不需要这种级别的锁定，我强烈建议在实例化 TransactionScope 时将隔离级别设置为限制较少的选项 (ReadCommitted):

var scopeOptions = new TransactionOptions();scopeOptions.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;scopeOptions.Timeout = TimeSpan.MaxValue;使用 (var scope = new TransactionScope(TransactionScopeOption.Required,范围选项)){//你的代码在这里}

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 changes 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?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！