System.Transactions and ADO .NET 1.x IDbTransaction

Question

Has anyone done any work with mixing SysTx transactions when a legacy ADO .NET 1.x data access component is in play?  Has anyone done a resource manager for an IDbTransaction or connection?  What is your feeling on this appraoch?

-Scott

Answer 1

The transaction adapter to enable "LTM" transactions with Microsoft SQL Server 2000 is doing just that: http://blogs.msdn.com/florinlazar/archive/2005/09/29/475546.aspx  You shouldn't have any problem mixing the two.

 

Unless I'm missing some aspects of your question.

Answer 2

Thanks, Florin.  Much appreciated!