CODEWITHSUNDEEP
.netentity-frameworkcode-first
Johan Danforth
Johan Danforth

Reputation: 4589

EF code first inserting many rows

I'm using EF code first and I need to insert many rows into a table, a couple of thousand records, I have in a generic list. Just doing a foreach loop and adding each entity to the table and finish with a SaveChanges() takes quite a while.

Is there a bulky way of doing this with EF or code first or should I do SqlCommand or SqlBulkCopy instead? Also, is there something I can switch off in EF code first to make the inserts faster?

Thanks for the help!

Upvotes: 5

Views: 602

Answers (1)

Craig Stuntz
Craig Stuntz

Reputation: 126567

You can call SaveChanges() less often.

However, nothing you can do with the EF will approach the performance of something like SqlBulkCopy.

Upvotes: 1

Related Questions