distributed transactions

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Faik
Posts: 1
Joined: Sat 08 Nov 2008 16:30

distributed transactions

Post by Faik » Sat 08 Nov 2008 16:36

Does the MyDirect.NET provider support distributed transactions, automatically enlisting into existing transactions and thus taking part into distributed transactions with other providers (TransactionScope).

For instance:

using (TransactionScope scope = new TransactionScope())
{
// open a MySQL connection here
// update some data here
// if something fails here, exception is thrown, update db is rollbacked
scope.Complete();
// transaction is committed only now !
}

KW
Posts: 124
Joined: Tue 19 Feb 2008 19:12

Re: distributed transactions

Post by KW » Thu 22 Jan 2009 22:42

I too would like to know if mysql supports transaction scope.

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 23 Jan 2009 09:33

We will implement this functionality in the future builds. dotConnect for MySQL doesn't support TransactionScope now.

Post Reply