zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

5 results in tag: stored-procedures

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...
c# sql sqlbulkcopy stored-procedures
asked by user1531248

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...
.net c# sqlbulkcopy sql-server stored-procedures
asked by rudimenter

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...
c# sqlbulkcopy sqltransaction stored-procedures triggers
asked by Nikhil Chavan

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...
c# sql sqlbulkcopy sql-server stored-procedures
asked by Jhe

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...
database sqlbulkcopy sql-server stored-procedures
asked by user5583732

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!