Update Multiple Rows in Entity Framework from a list of ids

Question

I am trying to create a query for entity framework that will allow me to take a list of ids and update a field associated with them    Example in SQL   UPDATE Friends SET msgSentBy    1234  WHERE id IN  1  2  3  4    How do I convert the above into entity framework

User · Answer

I think you are looking for below method:

var idList=new int[]{1, 2, 3, 4};
using (var db=new SomeDatabaseContext())
{
    var friends= db.Friends.Where(f=>idList.Contains(f.ID));
    friends.ForEachAsync(a=>a.msgSentBy='1234');
    await db.SaveChangesAsync();
}

This should be the efficient way of handling this.

User · Answer

something like below   var idList new int   1  2  3  4   using  var db new SomeDatabaseContext          var friends  db Friends Where f  gt idList Contains f ID   ToList        friends ForEach a  gt a msgSentBy  1234        db SaveChanges        UPDATE   you can update multiple fields as below   friends ForEach a   gt                                                   a property1   value1                           a property2   value2

User · Answer

var idList new int   1  2  3  4   var friendsToUpdate   await Context Friends Where f   gt       idList Contains f Id  ToListAsync     foreach var item in previousEReceipts      item msgSentBy    quot 1234 quot      You can use foreach to update each element that meets your condition  Here is an example in a more generic way  var itemsToUpdate   await Context friends Where f   gt  f Id     lt someCondition gt   ToListAsync     foreach var item in itemsToUpdate       item property   updatedValue    Context SaveChanges    In general you will most probably use async methods with await for db queries

User · Answer

I have created a library to batch delete or update records with a round trip on EF Core 5  Sample code as follows  await ctx DeleteRangeAsync b   gt  b Price  gt  n    b AuthorName     quot zack yang quot     await ctx BatchUpdate    Set b   gt  b Price  b   gt  b Price   3   Set b  gt b AuthorName b  gt b Title Substring 3 2  b AuthorName ToUpper     Set b   gt  b PubTime  b   gt  DateTime Now   Where b   gt  b Id  gt  n    b AuthorName StartsWith  quot Zack quot     ExecuteAsync     Github repository  https   github com yangzhongke Zack EFCore Batch Report  https   www reddit com r dotnetcore comments k1esra how to batch delete or update in entity framework

[c#] Update Multiple Rows in Entity Framework from a list of ids

Examples related to c#

Examples related to sql

Examples related to asp.net-mvc

Examples related to entity-framework

Examples related to sql-update