Why doesn't NHibernate support batching on MySql

Question

I've found a couple places where people say it's not supported, but I can't find what the root cause is.

• Is there an issue with the mysql ado.net provider?
• Is there something about MySql itself?
• Has it just not been implemented?

I recently found this patch for nHibernate that may resolve the issue, has anyone verified this as a workaround?

Is there another unsupported workaround?

Answer 1

• Has it just not been implemented?

Is the right answer.

The patch using a reference to MySql.Data will not get into the trunk in its current form because of the reasons mentioned by Rippo.

However, you don't need to compile NH with the patch. You can just inject the new Batcher.

It's as easy as:

config.DataBaseIntegration(
       db => db.Batcher<MySqlClientBatchingBatcherFactory>());