Software Is Hardwork

ISimplicityAffinative: The endless pursuit of anti-complexity.
The technology-centric blog of D. P. Bullington <dpbullington@hotmail.com>...
Blog Archive

Mixing Transaction Technologies is a Recipe for Disaster
Monday, March 3, 2008

When it comes to database transaction management, you have three choices: ADO.NET data source transactions (IDbTransaction, etc.), SQL transactions (TSQL ‘begin tran’, etc.), and MSDTC transactions (System.Transactions, COM+, etc.). You must choose which technology fits your needs but do not mix technologies; you will pay for it when things go awry.

0 comments:

Blog Archive

© D. P. Bullington, all rights reserved.
Everything posted on this blog is my personal opinion and does not necessarily represent the views of my employer or its clients.