NHibernate MySql事务不会回滚(NHibernate MySql transaction does not rollback)

 我用一个MySql数据库使用nhibernate。 
 
 大多数CRUD操作按预期工作，除了回滚事务。 下面的代码是我的; 非常简单，创建一个实体，保存它，然后回滚。 
 
using (var tran = accountRepository.Session.BeginTransaction())
        {
            var newUser = new User();
            newUser.Username = "testuser1002";

            accountRepository.Session.Save(newUser);

            tran.Rollback();
        }
 
 代码产量预期会导致我的SqlServer配置，但是，它不适用于MySql配置。 这两种配置几乎相同。 

i am using nhibernate with a MySql database.
 
Most CRUD operations work as expected except rolling back a transaction. The following code is what i have; really straightforward, create an entity, save it, then rollback.
 
using (var tran = accountRepository.Session.BeginTransaction())
        {
            var newUser = new User();
            newUser.Username = "testuser1002";

            accountRepository.Session.Save(newUser);

            tran.Rollback();
        }
 
The code yield expected result in my SqlServer configuration, however, it does not work with the MySql configuration. These 2 configurations are pretty much the same.

原文：https://stackoverflow.com/questions/6659631