TransactionScope & SQL Server 2000

m.harper posted on Friday, September 15, 2006

 

Is there anyway to create a transaction using the CSLA TransactionScope (System.Transaction) against a SQL Server 2000 database without going through MSDTC?  I am using a separate DAL and I want the business object to control the transaction.

 

Thanks,

Michael

tetranz replied on Friday, September 15, 2006

m.harper:

Is there anyway to create a transaction using the CSLA TransactionScope (System.Transaction) against a SQL Server 2000 database without going through MSDTC?  I am using a separate DAL and I want the business object to control the transaction.

I actually searched for this on Google a few months ago and one of the first links I found was:

http://lhotka.net/Article.aspx?area=4&id=39c79955-ddc9-42c7-a657-d5c2ed49975e