Support for System.Transactions?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Alex Davidson
Posts: 1
Joined: Wed 20 Dec 2006 12:50

Support for System.Transactions?

Post by 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 (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?

Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 21 Dec 2006 08:55

Unfortunately, we do not support System.Transactions.

Post Reply