Support for System.Transactions?

Support for System.Transactions?

Postby Alex Davidson » Wed 20 Dec 2006 12:56

We use MySQLDirect.NET with LLBLGen as a data access layer, tested with MbUnit. One of the tests ensures that the database is being rolled back between tests. For some reason, this always fails on the MySQL database. All data inserted into the database inside a transaction scope is being retained,. even if the scope is rolled back.

The rollback functionality makes use of Enterprise distributed transactions. LLBLGen's docs state that the data provider must support the System.Transactions namespace for rollback to work correctly with LLBLGen assemblies.

We're currently using version 3.50.14.0 (according to the GAC) of the MySQLDirect.NET assembly, under .NET 2.0, against a MySQL 5.0 database with InnoDB tables. Does this version of the provider support distributed transactions via System.Transactions?
Alex Davidson
 
Posts: 1
Joined: Wed 20 Dec 2006 12:50

Postby Alexey » Thu 21 Dec 2006 08:55

Unfortunately, we do not support System.Transactions.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL