DB2 and System.Transactions.TransactionScope

[Mesan]

I was wondering if anyone here knows of a good howto or article about
using transaction features in ADO.Net 2.0 with DB2 (particularly DB2
v7).


ADO.Net 2.0 is close enough to release that I'd expect to see more
written about it, particularly if the improvements are as large as I've
been led to believe but I have been unable to find a good resource.
Any help or direction as to how I can take advantage of the new
System.Transactions

 

[Sahil Malik]

Mesan,

To the best of my knowledge, System.Transactions currently does not work
with DB2, however it would be very reasonable to expect that such support is
announced in the near future..

However, it would not be too difficult to subclass their DB2Connection, and
hack it to write your own RM that enlists in transactions in a durable
fashion.

Here is an example of Transacted File Copy I had written earlier,
http://codebetter.com/blogs/sahil.malik/archive/2005/04/28/62604.aspx ,
enlisting a DB2Connection in a transaction wouldn't be too difficult.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx