EFBatch 1.0.0

EFBatch - Entity Framework Core Batch Operations

EFBatch is an extension for Entity Framework Core that enables efficient batching of SQL commands such as bulk update, delete, and insert-from-query. It integrates seamlessly with EF Core's DbContext and transaction management, allowing you to execute multiple DML operations in a single database roundtrip.

Features

• Batch Update: Update multiple records with a single SQL command.
• Batch Delete: Delete multiple records efficiently.
• Batch Insert From Query: Insert records into a table based on a LINQ query.
• Transaction Support: All batch operations participate in the current transaction or create a new one if needed.
• EF Core Integration: Works with EF Core's change tracking and SaveChanges/SaveChangesAsync flow.

Installation

Getting Started

1. Inherit from BatchingDbContext

public class HRContext : BatchingDbContext<HRContext>
{
    public HRContext(DbContextOptions<HRContext> options) : base(options)
    {

    }
// CODE REMOVED FOR BREVITY...
}

2. Usage Examples

Batch Delete

 _hrContext.BatchDelete(context => context.PositionRoleGroup.Where(x => x.PositionId == positionUpdateRequest.PositionId));
 await _hrContext.SaveChangesAsync();

Batch Update

  _hrContext.BatchUpdate(context => context.Position.Where(x => x.Id == positionUpdateRequest.PositionId),
      x => x.SetProperty(y => y.Name, positionUpdateRequest.Name));
await _hrContext.SaveChangesAsync();

Batch Insert From Query

 _hrContext.BatchInsertFromQuery(context =>
             context.Position
             .Where(x => !x.RoleGroups.Any(y => y.Id == rolegroupid))
             .Select(x => new PositionRoleGroup(x.Id, rolegroupid)));
await _hrContext.SaveChangesAsync();

How It Works

• Batching: When you call a batch method (BatchUpdate, BatchDelete, BatchInsertFromQuery), the SQL command is intercepted and queued.
• Execution: On SaveChanges or SaveChangesAsync, all batched commands are executed in a single transaction, followed by EF Core's normal change tracking operations.
• Transactions: If a transaction is already open, batch commands participate in it. Otherwise, a new transaction is created.
• Logging: Logging happens just the way EF core does.

API Reference

Notes

• All batch operations are executed before EF Core's tracked changes are saved.
• You must call SaveChanges or SaveChangesAsync to execute batched commands.
• Batched commands are cleared after each save operation.

License

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