Can multiple Entity Framework Data Contexts be used within a single TransactionScope?

Question

I'm attempting to use multiple EntityFramework 6 DataContexts in a TransactionScope using{}.

I get the following Exception

A first chance exception of type 'System.Data.Entity.Core.EntityException' occurred in mscorlib.dll

Additional information: The underlying provider failed on Open.

Inner Exception 1

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.

Inner Exception 2

The transaction manager has disabled its support for remote/network transactions.

(Exception from HRESULT: 0x8004D024)

The code works fine without the TransactionScope.

Here are the questions I need answered:

What is the best way to apply transactions to two datacontexts being used at the same time? What am I doing wrong?

Do the contexts address different databases? – Gert Arnold Dec 14 '13 at 23:38 — Gert Arnold, Dec 14 '13 at 23:38
Different databases and also different servers. – Chris Dec 16 '13 at 18:17 — Chris, Dec 16 '13 at 18:17

score 1 · Accepted Answer · edited May 23 '17 at 12:14

1

It's not EF that's stopping you, but DTC. DTC is needed when using two or more simultaneous connections to MSSQL.

See http://msdn.microsoft.com/en-us/library/dd327979.aspx

ps. Duplicate of MSDTC issue with transactions in ADO.NET Entity Framework

edited May 23 '17 at 12:14

Community

1
1

answered Dec 14 '13 at 01:30

Will

2,512
14
19

I had tried this before asking the question and did it wrong originally. I tried it again today and it solves the problem. Thank you for your answer! – Chris Dec 16 '13 at 18:28

Can multiple Entity Framework Data Contexts be used within a single TransactionScope?

1 Answers1