MySql BulkCopy/Insert from DataReader
- by Sky Sanders
I am loading a bunch of rows into MySql in C#. In MS Sql I can feed a DataReader to SqlBulkCopy, but the MySqlBulkCopy only presents itself as a bootstrap for a load from file.
So, my current solution is using a prepared command in a transacted loop.
Is there a faster way to accomplish bulk loading of MySql using a DataReader source?