Update multiple entities in MVC4 with LINQ, SQLquery

Question

Is it possible to update/remove multiples entities, for example

[HttpPost, ActionName("removeresponsible")]
public ActionResult removeresponsibleaction(Responsible modelo)
{
    Responsible responsible = db.Responsibles.Single(x => x.responsible_id == modelo.responsible_id);
    db.Responsibles.Remove(responsible);
    db.SaveChanges();
    ViewBag.responsible = db.Responsibles.ToList();
    return View("responsiblemanager");
}

This code works with one single responsible with an unique id, but how can I do it if there are many responsible with the same id? For example, I know that with SQL it would be something like this "delete from table where responsible_id=3".

Selman Genç · Accepted Answer · 2014-10-13 22:21:43Z

1

If you are using Entity Framework 6 you can use RemoveRange method:

var responsibles = db.Responsibles.Where(x => x.responsible_id == modelo.responsible_id).ToList();
db.Responsibles.RemoveRange(responsibles);

answered Oct 13, 2014 at 22:21

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Richard Over a year ago

Thanks for your quickly answer, i tried it and it worked perfectly

failedprogramming · Accepted Answer · 2014-10-13 22:32:08Z

0

If you aren't using EF 6, you will have to loop through your list of models, and delete each one separately.

e.g.

[HttpPost, ActionName("removeresponsible")]
public ActionResult removeresponsibleaction(IEnumerable<Responsible> models)
{
    foreach(var model in models)
    {
        Responsible responsible = db.Responsibles.Single(x => x.responsible_id == model.responsible_id);
        db.Responsibles.Remove(responsible);
    }
    db.SaveChanges();
    ViewBag.responsible = db.Responsibles.ToList();
    return View("responsiblemanager");
}

answered Oct 13, 2014 at 22:32

failedprogramming

2,52220 silver badges21 bronze badges

1 Comment

Richard Over a year ago

thanks for your answer, i tried it on EF 5.0.0.0 too and worked, it's easier in EF 6 but it's also helpful to know how to when there is no access to EF 6

Collectives™ on Stack Overflow

Update multiple entities in MVC4 with LINQ, SQLquery

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related