Bulk Operations is a library that allows to overcomes SqlBulkCopy limitations by adding high-performance bulk operations to insert, update, delete and merge.

SQL Server - Benchmarks

As fast as SqlBulkCopy for insert but with way more capabilities

Support Multiple SQL Providers:

• SQL Server 2008+
• SQL Azure
• SQL Compact
• MySQL
• SQLite
• PostgreSQL
• Oracle

Support Multiple Datasources:

• Entity
• DataTable
• DataRow
• DataReader
• DataSet
• Expando Object

PM> Install-Package Z.BulkOperations

* PRO Version unlocked for the current month

You need to output the newly generated identity value, but SqlBulkCopy does not support it.

Map your identity column with output direction.

var bulk = new BulkOperation(connection);

bulk.ColumnMappings.Add("CustomerID", ColumnMappingDirectionType.Output);
// ... mappings ...

bulk.BulkInsert(dt);

You can also output concurrency column (Timestamp) or any other column values. All kinds of mapping directions are supported, including "Formula" to use with a SQL Formula.

You have a list of entities to insert, but SqlBulkCopy doesn't support entity and lambda expression mapping.

Create generic bulk operations with your entity type and use lambda expression for your column input, output, and primary key mapping.

var bulk = new BulkOperation<Customer>(connection);

bulk.ColumnInputExpression = c => new { c.Name,  c.FirstName };
bulk.ColumnOutputExpression = c => c.CustomerID;
bulk.ColumnPrimaryKeyExpression = c => c.Code;

bulk.BulkMerge(customers);

Get rid of hardcoded string and use strongly-typed lambda expressions.

You have a DataTable which columns name match name in the database, but SqlBulkCopy throws an error because name matches are case insensitive.

Turn off case sensitivity with IsCaseSensitive property.

var bulk = new BulkOperation(connection);

bulk.IsCaseSensitive = false;

bulk.BulkMerge(dt);

Remove useless code that would have required you to create your own mapping and keep the essentials.

PRO Version unlocked for the current month

Learn more about the PRO Version

The best way to contribute is by spreading the word about the library:

• Blog it
• Comment it
• Star it
• Share it

A HUGE THANKS for your help.

• Projects:
  • EntityFramework Extensions
  • Dapper Plus
  • C# Eval Expression
• Learn Websites
  • Learn EF Core
  • Learn Dapper
• Online Tools:
  • .NET Fiddle
  • SQL Fiddle
  • ZZZ Code AI
• and much more!

To view all our free and paid projects, visit our website ZZZ Projects.