When to Use TransactionScope / Begin Tran .?

hello @santosh

 

I prefer TransactionScope because they'd still work 'across boundaries' (because they invoke MSDTCs), so you can have it writing to multiple databases. But that's a small point. TransactionScopes are pretty smart, they'll participate in all of the transactions within it and in all of the code that's being executed in that block even if it has implicit transactions as Linq to Sql does, so unless I'm mistaken, you can have a TransactionScope on the outside and multiple mini-transactions on the inside, but the nested transactionscopes can't rollback.

 

you can refer these site for better understanding

 https://msdn.microsoft.com/en-us/library/ms172152%28v=vs.90%29.aspx

 

http://www.codeproject.com/Articles/570915/TutorialplusonplusUnderstandingplusTransactionsplu 

Hello,

 

read below link-

http://www.codeproject.com/Articles/522039/A-Beginners-Tutorial-for-Understanding-Transaction