Lets you efficiently bulk load a SQL Server table with data from another source.
The SqlBulkCopy class can be used to write data only to SQL Server tables. But the data source is not limited to SQL Server; any data source can be used, as long as the data can be loaded to a DataTable instance or read with a IDataReader instance.
Using the SqlBulkCopy class, you can perform:
- A single bulk copy operation
- List item Multiple bulk copy operations
- List item A bulk copy operation within a transaction
Link to Microsoft Help Documentation: Microsoft SqlBulkCopy Documentation
