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

Question

asp.net-mvc-5 c# entity-framework

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 ?

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).

View more on Stack Overflow

MJVM · Accepted Answer · 11/28/2014 7:05:08 PM

This one liner will do it:

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

MJVM