Update Multiple Rows in Entity Framework from one id

Question

I am trying to create a query for Entity Framework that will allow me to take one id and update a field associated with it.

Example in SQL:

UPDATE Recibo
SET Estado = 3
WHERE IdApartado IN (7)

How do I convert the above to Entity Framework?

have a look on this link: https://stackoverflow.com/questions/21592596/update-multiple-rows-in-entity-framework-from-a-list-of-ids — Hasan Gholamali, Jul 15 '18 at 05:36

Hooman Bahreini · Accepted Answer · 2022-11-07T17:42:21.737

2

There are multiple ways of doing it, perhaps, the easiest way would be to read the records, edit them and save them, as explained here:

using (var dbContext = new DbContext())
{
    // read 
    var records = dbContext.Recibo.Where(r => r.IdApartado == 7).ToList();

    // update
    foreach (r in records)
    {
        r.Estado = 3;
    }

    // save
    dbContext.SaveChanges();
}

edited Nov 07 '22 at 17:42

answered Jul 15 '18 at 07:03

Hooman Bahreini

14,480
11
70
137

score 0 · Answer 2 · answered Jul 15 '18 at 06:57

Two ways to do in clause in EF:

first is Contains:

return dbContext.Query<R>.Where(r => subset.Contains(r.Id)).ToList();

second is foreach with contains:

 return dbContext.Query<R>.Where(r => subset.Contains(r.Id)).ToList().ForEach(a => a.id = "7");

this is because the best equivalent for sql in in EF is Contains.

Update Multiple Rows in Entity Framework from one id

2 Answers2