Delete multiple Items from a List of Id's using Entity Framework

Question

I need to delete multiple Ids from a List of Ids.

public IHttpActionResult Delete(List<string> IDs)
{
    DealBazarEntities.Restaurants.RemoveRange(IDs);
    DealBazarEntities.SaveChanges();
}

But RemoveRange does not allow multiple ids , it expect only List<entities>.

Yes, I know that , if I send list of entities to server instead of sending List of ids , Then I can easily accomplish this. But I don't like that.

Again, I don't want to use foreach loop to loop through every Ids.

DealBazarEntities.Restaurants.RemoveRange(DealBazarEntities.Restaurants.Where(r => IDs.Contains(r.ID))); — user3559349
– user3559349, Commented Feb 14, 2016 at 7:32
Wow... It's working like a charm.... Thanks. You saved my lots of time again. :) — Bimal Das
– Bimal Das, Commented Feb 14, 2016 at 8:07

Bimal Das · Accepted Answer · 2016-02-16 07:11:16Z

16

According to the answer of Stephen Muecke's answer given into comment section in the question , the solution is :

DealBazarEntities.Restaurants.RemoveRange
(DealBazarEntities.Restaurants.Where(r => IDs.Contains(r.ID)));

answered Feb 16, 2016 at 7:11

Bimal Das

2,0125 gold badges33 silver badges55 bronze badges

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

2 Comments

JohnnyHK Over a year ago

Good answer, but note that when I profiled this, it executed an initial SELECT and then separate DELETE statements per matched ID, rather than one DELETE that used IN. So it's not quite as efficient as it could be.

Bimal Das Over a year ago

@JohnnyHK I think you can execute raw sql command from EF in this scenario.

Collectives™ on Stack Overflow

Delete multiple Items from a List of Id's using Entity Framework

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related