How do I use TransactionScope in C#?

Answer 1

If you are using SQL Server 2000, System.Transactions.TransactionScope will cause all transactions to be promoted to Distributed Transactions, requiring MS Distributed Transaction Coordinator to be running.

You can fix this by starting the MSDTC service, upgrading to SQL Server 2005, or implement something like my codeproject solution: http://www.codeproject.com/KB/database/typed_dataset_transaction.aspx

I've never needed to do it, but you should also check Ocdecio's answer for configuring the network security settings for DTC, too.

Answer 2

Control Panel - Administrative Tools - Component Services - My Computer properties - MSDTC tab - Security Configuration tab - Network DTC Access (checked) / Allow Remote Clients (checked) / Allow Inbound (checked) / Allow Outbound (checked) / Enable TIP Transactions (checked)

Reboot computer.

Answer 3

Depending on the backend you are using, TransactionScope often requires the Distributed Transaction Manager to be enabled. Some details are on this MSDN blog.

Also, if you use multiple resources, DTC may be required. Enabling DTC may be required in your situation, or making sure you're using SQL Server 2005 and sticking to what would be doable in lightweight transactions.

Answer 4

You need to enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool.

Answer 5

You need to enable network DTC access for both the database server and the server where the application runs on.

You will also need to verify that connections will not be blocked by a firewall. Since a connection will be initiated from the database server to the application machine, it is equally important to add MSDTC to the list of firewall exceptions on the application machine.

Answer 6

I had the same problem running integration tests.

I posted a question about this here

but eventually I found a way around it. Although, I wouldn't recommend doing that for production code. I was doing it within the context of testing.