Learn how to use the class SqlBulkCopy from Data.SqlClient to load data into SQL Server with ease.
Using the class SqlBulkCopy from the System.Data.SqlClient namespace, you can load data into SQL Server very quickly
You direct SqlBulkCopy at a SQL Server table in your database and then pass a DataTable, array of DataRows to the WriteToServer method, which will then stream that data into SQL Server.
#softwarenuggets