EntityFramework.BulkOperations

A lightweight library for Entity Framework and Entity Framework Core that provides efficient bulk operations specifically optimized for SQL Server.

Features

• BulkSaveChanges: A high-performance alternative to the standard SaveChanges when dealing with a large number of entities.
• BulkUpsert: Efficiently insert or update entities in bulk using SQL Server's MERGE statement.
• Support for Entity Framework 6 and Entity Framework Core.
• Async support for all operations.
• Uses SqlBulkCopy for maximum performance during data transfer.

Installation

You can install the package via NuGet:

# For Entity Framework 6
dotnet add package BulkOperations.EntityFramework

# For Entity Framework Core
dotnet add package BulkOperations.EntityFrameworkCore

Usage

BulkSaveChanges

Instead of calling context.SaveChanges(), which sends entities to the database one by one, use BulkSaveChanges() to process them in batches:

using BulkOperations.EntityFramework; // or BulkOperations.EntityFrameworkCore

// ... add many entities to the context ...
foreach (var entity in entities)
{
    context.MyEntities.Add(entity);
}

context.BulkSaveChanges();

BulkUpsert

Perform a bulk insert or update (upsert) operation on a collection of entities. This method uses the primary key by default to match existing records.

var entities = new List<MyEntity> { ... };
context.BulkUpsert(entities);

You can also specify a custom set of fields to use for matching and updating:

context.BulkUpsert(entities, x => new { x.ExternalId, x.Name });

Async Operations

All methods have asynchronous counterparts for better scalability:

await context.BulkSaveChangesAsync();
await context.BulkUpsertAsync(entities);

Requirements

• SQL Server: This library uses SQL Server-specific features like SqlBulkCopy and MERGE statements.
• Entity Framework: Compatible with EF 6.3+ and EF Core.

License

This project is licensed under the MIT License - see the LICENSE file for details.