How to delete multiple records with Entity Framework ASP.Net MVC 5?

Question

I have Table like the following image:

enter image description here

how can I delete all records of table using Entity FrameWork based on ProjectId ?

possible duplicate of [How do I delete multiple rows in Entity Framework (without foreach)](http://stackoverflow.com/questions/2519866/how-do-i-delete-multiple-rows-in-entity-framework-without-foreach) — markpsmith, Nov 28 '14 at 16:44
I don't care with foreach or with out foreach I want a good way to delete records based on ProjectId — Benafsh Yalda, Nov 28 '14 at 16:45

score 82 · Accepted Answer · edited Nov 28 '14 at 19:05

82

This one liner will do it:

  db.ProRel.RemoveRange(db.ProRel.Where(c => c.ProjectId == Project_id));

edited Nov 28 '14 at 19:05

codegeek

answered Nov 28 '14 at 17:30

MJ X

2

Great and really simple and Perfect answer thanks very much it worked perfect – Benafsh Yalda Nov 28 '14 at 17:37
No problem I am happy to solved your problem. – MJ X Nov 28 '14 at 17:46
2

Simple and elegant solution, thanks! – Nimblejoe Sep 02 '15 at 23:29
not all the EF version support `RemoveRange()` if this is the case use Jesse Carter's answer instead – Djeroen Oct 23 '15 at 18:50
2

What @AtulChaudhary said. RemoveRange doesn't take an IQueriable so all it's doing is retrieving to the client all the data you want to delete, and then enumerating it. What's really required is a way of passing to the DB a condition that defines what you want to delete and have that done by the database without pointlessly copying all that data to the client. – Neutrino Nov 01 '17 at 14:02
2

Elegant solution, thanks – Jan 10 '20 at 15:18
1

Best one liner so far. Don't for get to add db.SaveChanges(); – Waller Dec 03 '20 at 21:48

score 16 · Answer 2 · edited May 23 '17 at 11:55

16

context.Projects.Where(p => p.ProjectId == projectId)
               .ToList().ForEach(p => context.Projects.Remove(p));
context.SaveChanges();

Taken from this very similar post (which should probably be marked as duplicate).

edited May 23 '17 at 11:55

Community

answered Nov 28 '14 at 16:45

Jesse Carter

I think you forgot to actually delete. – Kirk Woll Nov 28 '14 at 16:54
@KirkWoll ForEach(context.Projects.DeleteObject); deletes them – Jesse Carter Nov 28 '14 at 16:57
um...no, that's not right. – Kirk Woll Nov 28 '14 at 16:57
Oh, I see, `DeleteObject` lives on `ObjectContext`. (The current and now standard `DbContext` doesn't have that method) – Kirk Woll Nov 28 '14 at 17:00
Exactly It doesn't have DeleteObject Method – Benafsh Yalda Nov 28 '14 at 17:01
Exactly It doesn't have DeleteObject Method – Benafsh Yalda Nov 28 '14 at 17:01
Updated to use Remove instead – Jesse Carter Nov 28 '14 at 17:02
1

The solution I'm working on is in an older version of EF that doesn't support RemoveRange. I ended up using this as it was the next best solution I found. – Nimblejoe Sep 02 '15 at 23:33

score 6 · Answer 3 · answered Nov 28 '14 at 16:45

6

You can use DbSet.RemoveRange() and pass in an IEnumerable<Model>.

You build a list of models with ProjectId and pass them in RemoveRange() using the data context. Finally, call SaveChanges().

answered Nov 28 '14 at 16:45

beautifulcoder

I am new to ASP.Net MVC and Entity Framework could you give example in detail my Table Name is ProvRel how can I delete multiple records from this table Based on ProjectId – Benafsh Yalda Nov 28 '14 at 16:54
No problem, I will need to see more code. I need your data context and data model. – beautifulcoder Nov 28 '14 at 16:57
private MYDBContext db = new MYDBContext(); – Benafsh Yalda Nov 28 '14 at 16:59
not all the EF version support `RemoveRange()` if this is the case use Jesse Carter's answer instead – Djeroen Oct 23 '15 at 18:49

3 Answers3