SQLTransaction,Transactionscope & IDBtransaction

Thank you for your answers.

because its not working with SQLTransaction

Users can group two or more Transact-SQL statements into a single transaction using the following statements:

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");

}

}

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; 
} 
}

Hi

have a look of the link