Distributed transaction using C# and mysql

[newbie14]

Dear All,
I have a C# application where I need a distributed transaction. I need to update 2 database one local and one remote together that is two-phase commit. Is there any idea how to to do it with the current .net mysql connector? Any code snippet will be helpful? Thank you.

 

[BobRodes]

This article looks like what you want:

http://www.simple-talk.com/dotnet/.net-framework/.net-2.0-transaction-model/

 

[chiph]

Does the MySql client have a resource manager for participating in a DTC transaction?

(don't know -- just asking)

Chip H.

____________________________________________________________________
www.chipholland.com

 

[newbie14]

Dear Chiph,
I dont think so it has only windows have it. So how can I make my .net connector and DTC work together as I have gone through some articles say that .net connector does not support distributed transaction.

 

[chiph]

If the answer is "it's not supported" then it's not supported. All you can do is petition them to add that feature, or write it yourself.

Chip H.



____________________________________________________________________
www.chipholland.com