SqlBulkCopy Tutorial - Knowledge Base (KB)

Getting rows inserted with SqlBulkCopy

I am switching some of my Linq to Sql code to use SqlBulkCopy, and problem is I need to do two inserts of multiple thousands of rows into two tables....The service takes your batch of 10,000 links (imported from sitemap, backlink builders, etc), and chops...

EF Competing SaveChanges() Calls

I am building a batch processing system. Batches of ...Units... come in quantities from 20-1000. Each ...Unit... is essentially a hierarchy of models (one main model and many child models). My task involves saving each model hierarchy to a database as ...

Delete not working in transaction with sql bulk insert

I need to delete some records from table and then insert some records to the same table. This delete and insert process should be in transaction....Below is what i did.... using (SqlConnection sqlConn = new SqlConnection(connectionString)) { ...

Does SqlBulkCopy automatically start a transaction?

I am inserting data via ...SqlBulkCopy... like so:...public void testBulkInsert(string connection, string table, DataTable dt) { using (SqlConnection con = new SqlConnection(connection)) { con.Open(); using (SqlBulkCopy bulkCopy =...

How to use SqlBulkCopy with transaction on ReliableSqlConnection in sql azure

Our application on azure cloud service, We need to perform some operations on sql azure using the same transaction, (insert into and SqlBulkCopy) using ReliableSqlConnection to allow Transaction.Rollback If any steps fail ...but run this code: using ...

When/how are Constraints Checked in a SqlBulkCopy w/ Check Constraints enabled?

I am performing several ...SqlBulkCopy...'s in a single transaction, I need to be able to roll back easily if anything goes wrong. I'm bulk copying several tables that have foreign keys to each other. I want these constraints checked. I'm copying the pare...