BulkInsert for Entity Framework Core

Greg Frazer 0 Reputation points
2024-07-03T23:37:18.52+00:00

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

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
741 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Hongrui Yu-MSFT 1,765 Reputation points Microsoft Vendor
    2024-07-04T03:24:45.1066667+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.