SqlBulkCopy Tutorial - Knowledge Base (KB)

Thread is hung by SqlBulkCopy.WriteToServer. Abort is the name, although no one knows why.

Given:...A ...BenchMark... class that lets me know when something has completed....A very large XML file (~120MB) that has been parsed into multiple Lists...Some code:...SqlConnection con = null; SqlTransaction transaction = null; try { con = getCon();...

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...