Category Archives: Transactions

One transaction performance barrier broken

One of my biggest bugbears with .net transactions is that for all but the simplest of cases your transaction will be promoted from a light-weight transaction to a full-blown DTC transaction even when the only database you talk to was … Continue reading

Posted in Transactions | Leave a comment

Lightweight Transactions and Connection Pooling

System.Transactions, together with the appropriate data provider such as SQL 2005, provides a mechanism known as the Lightweight Transaction Manager (LTM). The basic principle is simple, if you open a transction and only talk to SQL 2005 then it won’t bother … Continue reading

Posted in Transactions | Leave a comment

Problems moving to System.Transactions

I’ve hit a couple of surprising issues when porting code from Enterprise Services (COM+) transactions to System.Transactions. The loss of the transactional component “Supports”. Nested transactions must have exactly the same isolation level.   “Supports” says to the transaction coordinator … Continue reading

Posted in Transactions | Leave a comment