SQLTransaction,Transactionscope & IDBtransaction

Question

What is the difference between SQLTransaction,Transactionscope & IDBtransaction in c#

rupali patil · Answer

Thank you for your answers. As i want to perform distributed transaction. I think i should prefer TransactionScope because its not working with SQLTransaction

Vasanth Natarajan · Answer

Transaction Users can group two or more Transact-SQL statements into a single transaction using the following statements: Begin Transaction Rollback Transaction Commit Transaction If anything goes wrong with any of the grouped statements, all changes need to be aborted. The process of reversing changes is called rollback in SQL Server terminology. If everything is in order with all statements within a single transaction, all changes are recorded together in the database. In SQL Server terminology, we say that these changes are committed to the database. TransactionScope You can easily maintain one transaction for multiple databases or a single database with multiple connectionstrings, using TransactionScope. using (TransactionScope transactionScope = new TransactionScope()) { try { orcmethod1() // Oracle DML operation sqlmethod2() // Sql DML operation orcmethod3() // Oracle DML operation // transactionScope.complete() // transactionScope.Dispose(); } catch (TransactionException ex) { transactionScope.Dispose(); MessageBox.Show( "Transaction Exception Occured" ); } } IDbConnection I'm entirely with you on the connection; that should be using , and there is no need for the explicit Close() . The transaction is a little bit trickier; the code shown is certainly overkill at the moment, but it is not entirely defined that Dispose() should do a rollback. Actually, that is what tends to happen in every implementation I've looked at, but it is slightly vexing that even DbTransaction (which most providers use) doesn't actually do this. Contrast to TransactionScope where it is explicitly defined that a Dispose() without a commit counts as a rollback. Because of that, I tend to use (excuse the C#): using(var conn = GetOpenConnection()) using(var tran = conn.BeginTransaction()) { try { // TODO: do work tran .Commit(); } catch { tran .Rollback(); throw; } }

Vinay Singh · Answer

Hi have a look of the link http://stackoverflow.com/questions/1270981/refactoring-ado-net-sqltransaction-vs-transactionscope http://stackoverflow.com/questions/542525/transactionscope-vs-transaction-in-linq-to-sql http://www.eranachum.com/PermaLink,guid,6e26a414-6a87-47a6-b9c0-e3be26298852.aspx http://www.eranachum.com/PermaLink,guid,6e26a414-6a87-47a6-b9c0-e3be26298852.aspx

SQLTransaction,Transactionscope & IDBtransaction

Answers (3)