Insert multiple rows into the database using Entity Framework in ASP.NET Web API

Question

I'm having an algorithm which creates a huge set of data in lists which have to be inserted into a database table. I can just put a loop through the entity save changes but is there a bit better way than that.

sa-es-ir · Accepted Answer · 2022-05-22 06:08:56Z

5

You can use AddRange for insert multiple rows into table like this:

var list=new List<YourModel>();

await dbContext.YouModels.AddRangeAsync(list);

await dbContext.SaveChangeAsync();

That works fine but it's recommended to use an extension for EF called EFCore.BulkExtensions with high performance like this:

var list=new List<YourModel>();
await dbContext.BulkInsertAsync(entities);

answered May 22, 2022 at 6:08

sa-es-ir

5,1902 gold badges20 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert multiple rows into the database using Entity Framework in ASP.NET Web API

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related