posted on Thursday, January 27, 2005 9:34 AM by scotts

Ado.Net and System.Transactions

There is an excellent article by John Papa entitled “Ado.Net and System.Transactions” in the February issue of MSDN Magazine. In the article, Johnny demonstrates some of the usage of the new .Net 2.0 System.Transaction namespace, and namely its relationship to what you might be doing now with both Ado.Net transactions and larger distributed transactions. He demonstrates how a fast lightweight transaction covering a single sql connection can be easily (automatically) promoted to a full distributed transaction spanning perhaps multiple connections and other DTC participants like MSMQ. This can all take place within a single transaction context (using TransactionScope), without inheriting from Servicedcomponent. This is good stuff - check it out!

Comments