Delete SQL IN way using Entity Framework

Question

I am trying to delete multiple rows in EF5.

closer i found is How do I delete multiple rows in Entity Framework (without foreach)

Am struck on how to proceed on this as i need to use LINQ(SQL IN)Version and i dont want to execute SQL.

I have a List of ID's and i need to pass it to IN. How do i implement in LINQ to Entities(EF)

SQL Version of what am tryin to do:

DELETE FROM TEST WHERE TESTID IN (2,3,4,5)

and i need to pass IN parameters from LIST<ID>.

What is the best way to implement this in EF?

Thanks

So http://stackoverflow.com/a/13903501/212121 and using `Contains` does not help? — Giedrius, May 23 '13 at 06:24
It does! but i thoought ll get better way fr my scenario with passing LIST and posted hre ! — user2067567, May 23 '13 at 06:29
This is not a task for LINQ! LINQ is a query language for data selection not for executing commands! — Jan P., May 23 '13 at 06:52

Jan P. · Accepted Answer · 2013-05-23T10:49:06.337

5

You have to use a loop. Your problem is just a cosmetic one, because after using:

var foo =
    from item in db.Test
    where idlist.Contains(item.TESTID)
    select item;

foreach (var item in foo)
{
    db.Entry(item).State = EntityState.Deleted;
}

db.SaveChanges();

the EF will create someting like

DELETE FROM TEST WHERE TESTID IN (2,3,4,5)

for you.

edited May 23 '13 at 10:49

answered May 23 '13 at 06:56

Jan P.

3,261
19
26

The DeleteObject method from entity also can be used. db.DeleteObject(item); – sexta13 May 23 '13 at 10:15

Delete SQL IN way using Entity Framework

1 Answers1