How to use ADO.Net DataTable to bulk-insert many records into database table?
Posted on 2009-05-07
Is it possible to create a DataTable object, define a few columns, add a few thousand rows, connect it to a database table, then "sync" up and have it insert those rows into a SQL Server database table?
Is this reasonable efficient or is it still "under the covers" doing multiple inserts? (and in that case no need to go through all the hassle of using the DataTable approach?)
Has anyone tried this?
If so, what are the concrete steps of how to create these objects and assign properties to pull this off?