SqlBulkCopy Tutorial - Knowledge Base (KB)

When copying data in sql, add a column

I'm using SqlBulkCopy to bulk insert some records from one table into another table. The query is using a SqlDataReader to get the data. The one difference that matters (besides column order which is handled in the mappings) between the tables is that t...

How do I convert a generic list to a DataReader in.NET?

Hi I have a Populated Generic List in a winform and now wanna to send its data into a SQL server table as a bulk Copy. As I read the SqlBulkCopy Class, it needs a data reader as a source....Now, how can I convert it to a DataReader?...Thank you

Million inserts: SqlBulkCopy timeout

We already have a running system that handles all connection-strings (...db2..., ...oracle..., ...MSServer...)....Currently, We are using ...ExecuteNonQuery()... to do some inserts....We want to improve the performance, by using ...SqlBulkCopy()... instea...