Using System.Transactions

Topics: Service Factory Modeling Edition Forum
Feb 6, 2008 at 10:15 AM
Edited Feb 6, 2008 at 10:52 AM
I have Inherited an application built using Enterprise Library 3.1 (May 2007). There is a requirement to transactionalise a series of calls initiated within the BusinessLogic layer. It appears that MSDTC is required to be set up on both Application & Database servers to enable this to work. I would like to avoind the heavy weight MSDTC and the associated configuration nightmare that I will have when I come to ship the application and implement the transaction handlind with LTM transactions. There is no obvious way to set this up with the Data Access Layer that installs with the guidance package unless I am missing something (which I expect I am!)

Any help would be great!

BTW I am stuck to using SQL 2000

Feb 6, 2008 at 11:55 AM
You can find some information in these pages and threads:
Transactions Support and Transactions.
System.Transactions for Sql Server 2000 and Sql Server 2005 - TransactionScope and SqlTransaction.