Generate Multiple Insert Command from a .NET DataSet to MySql

ezekielen

Rate me:

2.33/5 (2 votes)

10 Jul 2016CPOL3 min read

13.9K

Dynamically generate SQL INSERT commands programmatically and run then in batches of hundreds to bulk load data from a .NET DataSet with multiple DataTables to MySql

This article show you how to dynamically build SQL insert statements from a set of data tables inside a data set and run them in parametrized batches to load the data into MySql Server tables with a huge performance than running it row by row.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

ezekielen

Spain

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Generate Multiple Insert Command from a .NET DataSet to MySql

Views

License

Comments and Discussions