SqlBulkCopy Tutorial - Knowledge Base (KB)

How to handle multiple SQL transactions through different .net(c#) threads

I have the following method for bulk insert of the data in tables. First my code populates the data in data tables and inserts this data in corresponding tables using the SqlBulkCopy claas of the .net ....I have requirement that data should get inserted i...

Is it possible to ALTER TABLE (DDL) in the middle of an DML transaction on the same table?

Say, you begin a SqlTransaction from C# inside which you are inserting data from a DataTable into a SQL table, but this data is A LOT of data, so you do it 'in chunks' with a SqlBulkCopy inside the SQL transaction and only commit the transaction if ALL th...

Keep log table inserted data in SqlTransaction Rollback C#

I am using SqlTransaction to BulkCopy data to a table in SqlServer database. There are several stored procedures which are called based on column values in inserted table. If there is any error, I am using Rollback to avoid dirty data in tables. I am logg...