CODEWITHSUNDEEP
.nettransactionscope
jgauffin
jgauffin

Reputation: 101150

TransactionScope and database connections

Do TransactionScope work with closed database connections?

using (var transaction = new TransactionScope(TransactionScopeOption.Required))
{
    // creates a new connection, does stuff, commit trans and close
    repos1.DoSomething(); 

    // creates a new connection, does stuff, commit trans and close
    repos2.DoSomething(); 

    transaction.Complete();
}

Upvotes: 7

Views: 2963

Answers (2)

Eric Petroelje
Eric Petroelje

Reputation: 60498

Yes, that should work fine. Internally, the connections should be kept open until the transaction completes. Keep in mind that DTC may be required if multiple connections are used though, even if they are to the same database.

Also, you don't mention which database you are using, but there were bugs in the MySQL implementation that caused this not to work. For MySQL, this was fixed in MySQL 5.1.3.

Upvotes: 5

Amy B
Amy B

Reputation: 110111

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.close.aspx

Transactions started through System.Transactions are controlled through the System.Transactions infrastructure, and are not affected by SqlConnection.Close.

Calling Close just means that your code is done with the connection. If the ADO.NET infrastructure still wants the connection (to complete a transaction, or for connection pooling), the connection remains open.

Upvotes: 5

Related Questions