>To use transaction scope, I am pretty sure you need to have Microsoft Distributed Transaction Coordinator configured whereas you don't if you use a plain old transaction.
Depends <s>... but yes you probably need to have it at least installed. If you open multiple connections then (ie. standard open then close scenario with multiple connections) TransactionScope will promote to a distributed transaction because it has to manage these multiple connections. If all operations are performed on a single connection though then the transactions uses plain ADO.NET transactions.
I haven't actually used this but I was just reading about this a couple of days ago doing some research.
+++ Rick ---
>
>HTH
>
>>Hi,
>>
>>We've been milling around somewhat - sometimes using the Transaction and sometimes the TransactionScope class and should probably be standardising on one or other.
>>
>>We're leaning towards TransactionScope because it looks cleaner/simpler and we haven't spotted any obvious cons...
>>
>>But if you've made this decision which did you choose (and why)?
>>
>>Regards,
>>Viv