Performing BULK operations with EF Core. RRS feed

  • Question

  • User-2027985745 posted

    I have been using Entity Framework for few months and I have come across a scenario where I need to store 1-2 million records in my PostgreSQL Db. I am using the NPGSQL npm package and saving my records using AddRange() method but it takes a lot of time.

    Do we have anything with EF Core in case to increase the performance with Bulk Data insertion. I have come across multiple articles showing Dapper ORM has better performance over EF Core in the case of bulk insertion.

    But I am an EF Core fan. I want to know if any optimum solution exists in EF Core to handle bulk insertion.

    Kindly provide your inputs and suggestions.



    Wednesday, May 19, 2021 4:58 AM

All replies