I have a list consisting of ~10,000 objects (let's say of class Person
) that I need to insert to a MySQL table. If I use the regular DbContext.SaveChanges()
, it takes 60-70 seconds to issue, which I need to reduce drastically. I've found several extensions for bulk-insertions:
Unfortunately, non seem to exist for MySQL databases. Does anybody know of one for MySQL? If not, could anyone give me an approach as to how I could make my own or adjust the aforementioned solutions? Thank you!
Fortunately it is available now for free: