Re: Update

[schizoid]

Hey Dan,

I have been using TransactionScope with ADO.NET 2.0 exactly as you mentioned, in so much as rolling back transactions amounted to not calling scope.Complete (e.g. if an exception is thrown).

Now, recently I tried moving to MySQL, and ran into the *exact* same issue as you. I wanted to migrate from SQL Server *to* MySQL, and I really can't. It's infeasible for me to make the change that you did since if I ever need to go back to SQL Server, then I won't be getting the benefits of TransactionScope.

I really think that MySQL needs to fix this issue to get more people using MySQL underneath .NET 2.0 apps. I would say this is of critical importance. For now, I will continue using SQL Server.

Kevin