distributed transactions

[Faik]

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]

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

[Shalex]

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