BulkInsert for Entity Framework Core

Question

Entity Framework core now has ExecuteUpdate and ExecuteDelete for doing large updates and deletes
But when is EF core going to get the much need BulkInsert that does the job of SQL SERVER's BCP

There are third party tools, but they are very expense and a little buggy

Please advise or consider a plan

Answer 1

Hi,@Greg Frazer. Welcome to Microsoft Q&A. 

Whether to allow EF to have Bulk functionality is discussed in the following link. You can refer to it:

Does EF Core support bulk-insert/update/delete? · Issue #7256 · dotnet/efcore (github.com)

 

In this discussion, the Bulk function will still be postponed.

 

The current temporary solution is still to use the three-party library mentioned above.

EFCore.BulkExtensions: https://github.com/borisdj/EFCore.BulkExtensions

EntityFramework.Extended: https://github.com/zzzprojects/EntityFramework.Extended

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.