Why is TransactionScope using a distributed transaction when I am only using LinqToSql and Ado.Net
- by Ian Ringrose
We are having problems on one machine, with the error message:
"MSDTC on server XXX is unavailable."
The code is using a TransactionScope to wrap some LingToSql database code; there is also some raw Ado.net inside of the transaction.
As only a single sql database (2005) is being accessed, why is a distributed transaction being used at all?
(I don’t wish to know how to enable MSDTC, as the code needs to work on the server with their current setup)