Entity Framework bulk functionalities (bulk insert,bulk delete)

Question

Entity Framework bulk functionalities (bulk insert,bulk delete)

Greivin Chaves 0

I'm currently working on an enterprise project that requires some logic for bulk functionalities using Entity Framework.

We found a couple of options but both are under licence:

EF. Core.BulkExtensions https://www.nuget.org/packages/EFCore.BulkExtensions
Z.EntityFramework.Extensions.EFCore: https://www.nuget.org/packages/Z.EntityFramework.Extensions.EFCore

Wondering if there is some other free options or if we need to decide to buy one of these license which is the best? thinking on support, pricing, etc.

Thanks

Anonymous

2024-02-20T03:16:32.08+00:00

Hi @greivin chaves , Welcome to Microsoft Q&A,

Regarding the batch operation function, EntityFrameworkCore.BulkExtensions and Entity Framework Extensions are two free open source projects. You can find more information on their GitHub page and install via NuGet. LINQ to SQL can also be used for simple database access and operations. It provides basic CRUD operations, and while it may not be as powerful as Entity Framework, it is still an option for some simple batch operations. Although Dapper is not an extension of Entity Framework, it is a lightweight object-relational mapping (ORM) tool that can be used with Entity Framework. It provides high-performance database access and has support for batch operations.
David V. Corbin [Atmosera] 6 Reputation points

2024-06-19T09:59:41.4+00:00

NOT free in many cases....
https://entityframework-extensions.net/licensing
Fabien Ménager 0 Reputation points

2025-06-22T08:39:59.4366667+00:00

I released recently a new project under MIT that I think is the fastest (and simplest, comparing to "raw" insert) way to insert data with EF Core :

https://phenx.github.io/PhenX.EntityFrameworkCore.BulkInsert/

See the benchmarks, comaring with other libraries, sometimes it's slower than a naive raw insertion method, but it's still a lot more simple.

1 answer

Your answer

Anonymous

2024-02-20T03:16:32.08+00:00

Hi @greivin chaves , Welcome to Microsoft Q&A,

Regarding the batch operation function, EntityFrameworkCore.BulkExtensions and Entity Framework Extensions are two free open source projects. You can find more information on their GitHub page and install via NuGet. LINQ to SQL can also be used for simple database access and operations. It provides basic CRUD operations, and while it may not be as powerful as Entity Framework, it is still an option for some simple batch operations. Although Dapper is not an extension of Entity Framework, it is a lightweight object-relational mapping (ORM) tool that can be used with Entity Framework. It provides high-performance database access and has support for batch operations.
David V. Corbin [Atmosera] 6 Reputation points

2024-06-19T09:59:41.4+00:00

NOT free in many cases....
https://entityframework-extensions.net/licensing
Fabien Ménager 0 Reputation points

2025-06-22T08:39:59.4366667+00:00

I released recently a new project under MIT that I think is the fastest (and simplest, comparing to "raw" insert) way to insert data with EF Core :

https://phenx.github.io/PhenX.EntityFrameworkCore.BulkInsert/

See the benchmarks, comaring with other libraries, sometimes it's slower than a naive raw insertion method, but it's still a lot more simple.

Answer 1

Karen Payne MVP 35,586 Volunteer Moderator

For a free option see EFCore.BulkExtensions. Did a test, six columns, 500,000 records in four seconds.

David V. Corbin [Atmosera] 6 Reputation points

2024-06-19T09:59:25.03+00:00

NOT Free in many cases....
https://entityframework-extensions.net/licensing

Share via

Entity Framework bulk functionalities (bulk insert,bulk delete)

1 answer

Your answer