Bulk-Insert to MySQL in Entity-Framework Core

bulkinsert entity-framework-core mysql

Question

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!

1
6
5/26/2017 4:04:23 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

0
11/30/2018 1:06:40 PM

Related Questions

How to use Bulk Insert in Entity Framework using Object Context?

I would like to use Object Context instead of DbContext to call Bulk Insert in Entity Framework 6. How can I do that?...I would like to do something like...readonly ...ObjectContext obContext...:...public void BulkInsert<T>(IEnumerable<T> items) where T : class, new() { obContext.BulkInsert(items); } ...But I am not able to do this.
asp.net-mvc c# entity-framework entity-framework-6 linq-to-entities
asked by user3661657

Bulk insert data entity framework 7

Normally In my previous project, I can do bulk insert by passing a list of object as code below...public void Create(List<ApplicationUserRole> item) { foreach (var data in item) { _dbContext.ApplicationUserRole.Add(data); } _dbContext.SaveChanges(); } ...But for now i keep hitting er...
asp.net-core c# entity-framework-core
asked by user998405

Entity Framework bulk inserts - creating a large number of objects / entities is the slow part?

The slow part in your “creating all the objects” section is the Detect Changes....You should always use AddRange over Add...Add: Detect changes for every object...AddRange: Detect changes only once (after all object are added)...This code should fix the slow part when creating objects:...DataTable ref1 = ConvertCSVtoDataTable(csv, firstRowsToDe...
c# entity-framework entity-framework-6
asked by Jonathan Magnan

All data is not inserted in MySql instance using Entity Framework Core

Using a MariaDb instance database (fork of MySql) and using Entity Framework Core, give me a problem I've never experienced before, hence this post as I have no idea what is going on, and hoping that some of you guys might've experienced this before....Problem...Take the following scenario. We have a table that look like this...News ---------------...
asp.net-core-mvc c# entity-framework-core mysql
asked by Detilium

Issue when inserting new entity with relationships to existing entities (Entity Framework Core 1.1.0 )

I have encountered an issue when inserting (...Add... method of EF API) or updating (...Update... method of EF API) entities holding reference properties to existing entities (I call existing entity an entity that already exists in the database, and has its PK properly set)....The model consists in ...Place..., ...Person..., ...Address..., and ...S...
c# entity-framework-core
asked by kall2sollies

How do I execute a bulk `INSERT IGNORE` with Entity Framework Extensions library

I'm trying to insert a large set of objects into the table but I don't have any efficient way to check if some records aren't already there. Every time I use this:...using Z.EntityFramework.Extensions.Core; ... await ac.BulkInsertAsync(query, (o) => { o.?? }); ...it just stops the insert each time it finds a duplicate. Is there a way to either run ...
.net c# entity-framework entity-framework-6 insert
asked by Reynevan

Bulk insert records and get their Id's after bulk insert in Entity Framework

I want to bulk insert 100,000+ rows into a table (which has a identity column which auto increments every time a new row is inserted)....What would be the fastest way to insert the rows with least performance impact?...After all rows are inserted, how do I get the list of ids of the rows that are recently inserted?...Note: I did the following but I...
c# entity-framework entity-framework-6 sql
asked by user3861992

Force inherited classes in ASP.NET Core Entity Framework Core to dedicated MySQL table

Having a model ...Thread... that should countain all attributes of another model called ...Post... I use inheritance:...class Post { public int Id{get;set;} public string Title{get;set;} // ... } class Thread: Post { public int ForumId{get;set;} // ... } ...EF Core put both in a single table and adds the column ...Discriminator....
asp.net-core c# ef-code-first entity-framework-core mysql
asked by Lion

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

It doesn't matter if you use Add in a foreach or AddRange, problem lies in SaveChanges method, as it stores changes in observed entities one by one I think. There are libraries out there that allows for real bulk insert of entities using under the hood mechanism of ...SqlBulkCopy...Link to EF Core library: ...EFCore.BulkExtensions...EDIT: For EF6 I...
c# c#-4.0 entity-framework entity-framework-6
asked by Adam Małek

Entity Framework Core Insert multiple entities similar to SQL single insert statement

You may generate the query and execute the same as per the following;...DatabaseContext.Database.ExecuteSqlCommand(yourQuery); ...Refer documentation ...here.... Even though it is relevant to EF, it is applicable to EF Core as well
entity-framework-core performance
asked by Christie

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow