Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?

What does it mean for an SqlConnection to be “enlisted” in a transaction? Does it simply mean that commands I execute on the connection will participate in the transaction? If so, under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction? See questions in code comments. My guess to each question’s answer … Read more

TransactionScope automatically escalating to MSDTC on some machines?

In our project we’re using TransactionScope’s to ensure our data access layer performs it’s actions in a transaction. We’re aiming to not require the MSDTC service to be enabled on our end-user’s machines. Trouble is, on half of our developers machines, we can run with MSDTC disabled. The other half must have it enabled or … Read more