Base solution for your next web application
Ends in:
01 DAYS
01 HRS
01 MIN
01 SEC
Open Closed

BulkInsert into table #7999


User avatar
0
sgeeks created

Hi,

Could you please guide me how to bulk of data insert at a time without using loop.

Thanks, Chandi


2 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team

    If you use EF Core with Sql server(https://docs.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.infrastructure.relationaloptionsextension.maxbatchsize?view=efcore-3.0) to insert data by default, it is already batch.

    Of course you can use the raw sql statement to batch insert data.

    There are also some third-party free/charged libraries. https://github.com/borisdj/EFCore.BulkExtensions https://entityframework-extensions.net/

  • User Avatar
    0
    ismcagdas created
    Support Team

    This issue is closed because it has not had recent activity for a long time.