Bug #110553 Contribution: Run inserts in batch command as one block

Description:
This bug tracks a contribution by Sebastian Schwarzhuber (Github user: cannero) as described in http://github.com/mysql/mysql-connector-net/pull/50

How to repeat:
See description

Suggested fix:
See contribution code attached

Contribution submitted via Github - Run inserts in batch command as one block 
(*) Contribution by Sebastian Schwarzhuber (Github cannero, mysql-connector-net/pull/50#issuecomment-1489037067): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_1293541369.txt (text/plain), 2.99 KiB.

Hello,

Thank you for the bug report and contribution.

Regards,
Ashwini Patil

Related to Bug#71832.

Posted by developer:
 
Fixed as of the upcoming MySQL Connector/NET 9.2.0 release, and here's the proposed changelog entry from the documentation team:

Added a new rewritebatchedstatements connection option that makes the
connector rewrite batched statements and execute them all at once in a
single block rather than one at a time, which is default behavior.

Note that this connection option impacts functions like
LAST_INSERT_ID().

Our thanks to Sebastian Schwarzhuber for the contribution.

Thank you for the bug report.