Entity Framework Batch Update

Introduction

Batch Update allows you to improve EF performance by updating multiple records in a database from a LINQ Query without loading entities.

Why Batch Delete?

For HUGE performance gains, everything is executed on the database side. To use batch update, you will need to use a third-party library.

Google Related Searches

• Entity Framework Update Without Loading
• Entity Framework Update Without Retrieving

StackOverflow Related Questions

• How to Bulk Update records in Entity Framework?
• Entity Framework update/insert multiple entities
• Batch update on object list using EntityFramework 6 and Linq

// using Z.EntityFramework.Plus; // Don't forget to include this.

// UPDATE all users inactive for 2 years
ctx.Users.Where(x => x.LastLoginDate < DateTime.Now.AddYears(-2))
         .Update(x => new User() { IsSoftDeleted = 1 });

Supported Libraries

Unsuported Libraries

Use these libraries at your risk!