EF - Updating multiple rows in a database without using a foreach loop

Question

My test code is:

using (var db = new MyDbContext()) { string fromUser = ""; //sender string toUser = ""; //receiver var messages = db.Message.Where(x => x.FromUser == fromUser && x.ToUser == toUser) .ToList(); foreach (var message in messages) { message.IsRead = true; db.SaveChanges(); } } 

My question is: is there another way to update the database without using a foreach in this case?

p / s: I mentioned these questions, but they all did not solve my problem:

• Updating multiple rows in datatable without loop

• updating multiple database records with linq to sql without a loop, is this possible?

• Update multiple rows without loop

Answer 1

You do not need SaveChanges () at each iteration. This will hit the database several times. Try:

 using (var db = new MyDbContext()) { string fromUser = ""; //sender string toUser = ""; //receiver var messages = db.Message.Where(x => x.FromUser == fromUser && x.ToUser == toUser) .ToList(); messages.ForEach(m => m.IsRead = true); db.SaveChanges(); }