Is there a non-profit alternative to Z.EntityFramework.Extensions?

Question

Entity Framework can be very slow with bulk inserts / updates / deletes. Even the frequently suggested settings for disabling AutoDetectChanges and / or ValidateOnSaveEnabled do not always help.

I came across Z.EntityFramework.Extensions on NuGet, but it seems to be a commercial product that will only work for a certain period of time.

https://www.nuget.org/packages/Z.EntityFramework.Extensions/

So far, I really only need BulkInsert (), BulkUpdate (), and BulkDelete ().

My question is:

Is there any reliable non-profit library that almost matches Z.EntityFramework.Extensions?

Thanks for any tips!

Answer 1

Disclaimer I own the Entity Framework Extension

You're right. This is a commercial product.

A free trial is provided every month, but you will have to purchase the product for the production environment.

Bulk insert

There are several free alternatives for BulkInsert, but be careful, they do not support all inheritance and associations and are no longer supported:

• https://www.nuget.org/packages/EntityFramework.BulkInsert-ef6
• https://github.com/MikaelEliasson/EntityFramework.Utilities

Disclaimer I own Entity Framework Plus

For batch update && Batch Delete, you can use this library:

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