Using Transactions With .NET/SQL Server

home
ado.net
view story

1 Kicks

Using Transactions With .NET/SQL Server(pragmaticarchitect.blogspot.com)

submitted by djankov(35) 2 years, 2 months ago

Here's how the .Net transaction manager works. In the transaction manager framework in .Net, SQL Server data provider acts as a durable transacted resource manager. What this means is that the transaction manager can do a two-phase commit with it if it needs to. Now, the transaction manager generally has two modes of operation: a so called LTM or lightweight transaction manager and a full-blown MSDTC-based distributed transaction. LTM-based transaction is essentially a single-resource manager transaction which can benefit from the optimization of a single-phase commit. The transaction manager also has a special mode in which it allows resource managers to upgrade its transaction to a distributed transaction, should more durable resource manager get enlisted, and only when needed.

add a comment |category: ADO.NET |Views: 5
Tweet