Batch Update a List of Record Entitiy Framework

Question

I have a list of updated objects. And I tried to update all records with only one database call.(one context.SaveChanges() command). This programme runs inside a windows service. My problem is instead of updating I am multiplicating all records on the database and adding duplicates. Following is my code.

//adding the list of updated customer objects to the list
context_CLTUS.Customer_Updates.AddRange(list.customerUpdateList);
foreach (var j in list.customerUpdateList) 
{
    //calling entity state modify for each record
    context_CLTUS.Entry(j).State = EntityState.Modified;
}
//save updated list in one db call.
context_CLTUS.SaveChanges();

I cannot clarify why all records are duplicating instead of updating. Could you please explain and help me on this. Thank you.

only thing you need here is context_CLTUS.SaveChanges(); remove rest of things — Sushil Mate, Jul 15 '17 at 05:48
Removing `AddRange` worked for me thank you for the comments! — thilanka1989, Jul 15 '17 at 16:13

Nico · Accepted Answer · 2017-07-15T06:08:40.490

1

Refer to this answer

You can try these solutions :

Swap update operation in a TransactionScope.
Set Configuration.AutoDetectChangesEnabled = false.
Try Entity Framework Plus, a high-performance enhancement library.

edited Jul 15 '17 at 06:08

answered Jul 15 '17 at 05:50

Nico

390
8
20

Tried Entity Framework Plus for the first time , Saved my time! thank you! – thilanka1989 Jul 15 '17 at 16:14
@thilanka1989 sorry for my misunderstanding, and in your case, maybe the comments above are easier, thanks for your vote too. – Nico Jul 16 '17 at 04:36

Batch Update a List of Record Entitiy Framework

1 Answers1