ASP.NET Entity Linq

Question

Searching here I see

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

can be used to remove a set of records. However, if you want to remove a large number of records, like 1000s or more, you don't want to bring them into memory. Can Linq do it, or do you do you need to drop into SQL?

Possible duplicate of bulk delete in entity framework

DavidG
– DavidG

2017-03-13 22:03:34 +00:00
Commented Mar 13, 2017 at 22:03 — DavidG
– DavidG, Commented Mar 13, 2017 at 22:03

ocuenca · Accepted Answer · 2017-03-13 22:04:32Z

1

There is a 3rd party library called EntityFramework.Extended that lets you do a batch to delete a set of specific rows. In your case it would be:

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

Just install this nuget package and execute the code I show above.

answered Mar 13, 2017 at 22:04

ocuenca

39.5k12 gold badges95 silver badges107 bronze badges

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

Collectives™ on Stack Overflow

ASP.NET Entity Linq

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related