How to Delete multiple records in Linq to Entity?

Question

I have a tblA in sql:

id  int  (primary key)
fid  int

data in tblA is:

i delete one record by following code:

DatabaseEntities obj = new DatabaseEntities();
int i = 2;
tblA t = obj.tblA.Where(x => x.fid == i).FirstOrDefault();
obj.DeleteObject(t);
obj.SaveChanges();

i delete multiple records by following code:

DatabaseEntities obj = new DatabaseEntities();
int i = 2;
while (obj.tblA.Where(x => x.fid == i).Count() != 0)
{
   tblA t = obj.tblA.Where(x => x.fid == i).FirstOrDefault();
   obj.DeleteObject(t);
   obj.SaveChanges();
}

Is there any solution for delete multiple records in linq to entity?

score 12 · Accepted Answer · answered Dec 08 '13 at 11:10

12

You can do the following, which is technically still a loop.

obj.tblA.Where(x => x.fid == i).ToList().ForEach(obj.tblA.DeleteObject);
obj.SaveChanges();

The alternative is calling the SQL directly.

answered Dec 08 '13 at 11:10

Marco

22,856
9
75
124

9

I am not able to find DeleteObject :( – Nithin Paul Dec 10 '14 at 05:19

score 2 · Answer 2 · edited May 23 '17 at 10:32

2

There is a extension provided at EntityFramework.Extended

to delete all object

//delete all users where FirstName matches
context.Users.Delete(u => u.FirstName == "firstname");

Additionally look into : How do I delete multiple rows in Entity Framework (without foreach)

edited May 23 '17 at 10:32

Community

1
1

answered Dec 08 '13 at 11:10

Parimal Raj

20,189
9
73
110

Is the `Delete` method been added in EF 5 or 6? Didn't know it yet – Marco Dec 08 '13 at 11:12
@Serv = its a extension for for entityframework! – Parimal Raj Dec 08 '13 at 11:13
@SamieyMehdi - i am using it myself, can i ask which version of ef ur using ? – Parimal Raj Dec 08 '13 at 11:19
Extension method working well for me. – TSmith Apr 07 '14 at 16:25

How to Delete multiple records in Linq to Entity?

2 Answers2

Linked