TransactionScope and SQL Transaction

Question

Please let me know.. Can I use TransactionScope and SQL Transaction (Begin trans and Commit trans) at the same time.

Thanks,

There's no need to really. It's either one or the other. See http://stackoverflow.com/questions/1270981/refactoring-ado-net-sqltransaction-vs-transactionscope — dash, May 03 '12 at 09:45

score 0 · Answer 1 · answered May 03 '12 at 09:47

Yes you can, but it is not recommended. Transactions are great, but they can lead to subtle concurrency problems (contention, deadlocks, and alike ...) that are hard to debug, so you should try to minimize the code inside transactions and manage them very carefully. If sometimes it's hard to people do it using a single technology, imagine using two...

TransactionScope and SQL Transaction

1 Answers1