Entity Framework Core(7) bulk update

Updating records with Entity Framework Core 1.0 without needing to Update/UpdateRange

In Entity Framework Core 1.0 when I do something like:...var products = _context.Products.ToList(); foreach (var prod in products) { prod.Status = 1; } _context.SaveChanges(); ...I believe it will automatically update all products in the list to have a Status of 1....If this is the case what happened to AddRange, UpdateRange, Add, Update, Rem...

Bulk Update in Entity Framework Core

If ...TimeEntry... has an association to ...Invoice... (check the navigation properties), you can probably do something like this:...var timeEntries = context.TimeEntries.Where(t => timeEntryIds.Contains(te.Id)).ToArray(); foreach(var timeEntry in timeEntries) invoice.TimeEntries.Add(timeEntry); context.Invoices.Add(invoice); //save the enti...

Bulk-Insert to MySQL in Entity-Framework Core

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:...EF extensions... (not free, so no option)...BulkExtensions...

Bulk register IEntityTypeConfiguration<> entity framework core

It can be done with reflection like this:...protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); // get ApplyConfiguration method with reflection var applyGenericMethod = typeof(ModelBuilder).GetMethod("ApplyConfiguration", BindingFlags.Instance | BindingFlags.Public); ...

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...

EF Core - adding/updating entity and adding/updating/removing child entities in one request

As usual, posting this question to StackOverflow helped me resolve the problem. The code originally didn't look like in the question above, but I was rather fixing the code while writing the question. ...Before writing the question, I spent almost a day trying to figure out what the problem was and so I tried different things, such as recreating en...

Entity Framework Core: Fail to update Entity with nested value objects

According to ...this EF Core GitHub ticket... you have to update the child/nested/owned type properties directly for it to track properly. This was supposed to be fixed in EF 2.1 (currently only available as a release candidate) but may have not made the cut. In 2.0.3 they updated the verbiage of the exception to:...InvalidOperationException: The i...

Add or Update child entities when updating a parent entity in Entity Framework Core

In a new project we are using Entity Framework Core instead of EntityFramework 6.2.0. Works good but it causes a problem when updating a parents children while also inserting new children....Example:...Current model:...public class Profile { public Profile() { Interests = new List<Interest>(); } [Key] [DatabaseGenerate...

Entity Framework Core: Update() method INSERTs instead of UPDATEs on dependent entity

It seems like EF Core is doing an INSERT instead of an UPDATE, and thus MySQL complains about a duplicate key. However, I am using the Update method on the DbSet and the entities do have primary keys set. This results in a DUPLICATE ENTRY error in MySql....Running VS 2019, EF Core 3.1.1 and ASP.NET Core 3.1...Model (I do not use Fluent config for r...

DateTime property causing new migration update even without any update on model in Entity Framework core

In entity framework, if I run the command "...add-migration <name>..." in package manager console, each and every time it creates migration with some update commands for the property datetime....Model:...public class TestDetailBase { public string TestTitle { get; set; } public int TotalTimeinMinutes { get; set; } public...