SqlBulkCopy Tutorial - Knowledge Base (KB)

Using SqlBulkCopy to get rows added

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

SaveChanges() Calls from EF Competitors

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

SQL bulk insert delete not functioning in transaction

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