SqlBulkCopy Tutorial - Knowledge Base (KB)

How to get auto-increment values after inserting records using SqlBulkCopy via c#

I am using ...SqlBulkCopy... class to insert bulk records but i want that newly generated ...auto-increment... values(primary key plays Foreign key in child table) because with the help of that values i am going to play with child tables(Foreign key) maki...

How to send large amount of Data To SqlServer Stored Procedure

I want to send large amounts of data from a .Net based application to the SQL Server. This Data Records are coming from a CSV file and should be funneled through a Stored Procedure on the SQL Server side. I know about SqlBulkCopy but SqlBulklCopy writes d...

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

Best practice for transferring a large amount of data. Using Stored Procedure or SQL Bulk Copy

I have a huge amount of data from one server's different databases and tables to be transferred into another server's different databases and tables. I've created a ...stored procedure... and my C# application doing is just passing a parameter into my sto...

Create procedure that will insert or update data from one temporary table to other 4 tables

I need to Create procedure that will ...insert or update data from the source table into the target1 table...Insert data into target2 table AND will get inserted ID from target1, target2 tables...Insert them into target table3...Insert target1.ID into tar...