Using LINQ to delete multiple rows in table using matching key from related table

Question

Suppose I have models (and tables) that look like below:

Program: ProgramId (PKey)
ProgramRegistration: ProgramRegistrationId (PKey), ProgramId (FKey)
CourseEnrollments: CourseEnrollmentId (PKey), ProgramRegistrationId (FKey)

What I need to do is that in a controller I am passing an id that happens to be the ProgramId. I want to bulk delete all rows (or items) in CourseEnrollments that have a matching record in ProgramRegistration with the passed parameter id = ProgramId.

So I figured I would do:

db.CourseEnrollments.Where(e => e.ProgramRegistration.ProgramId == id).ToList().Remove();

Question: Is the above approach of using navigation properties correct?

abatishchev · Accepted Answer · 2014-10-01 06:13:31Z

2

I solved it in the following manner instead:

var results = from c in vm.CourseEnrollments
              where c.ProgramRegistration.ProgramId == id
              select c;

foreach (var courseenrollment in results)
{
    db.CourseEnrollments.Remove(courseenrollment);
}
db.SaveChanges();

edited Oct 1, 2014 at 6:13

abatishchev

101k88 gold badges303 silver badges443 bronze badges

answered Sep 29, 2014 at 3:20

SKale

5711 gold badge6 silver badges16 bronze badges

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

1 Comment

abatishchev Over a year ago

Yes, that's correct. Almost the only way. In extensions methods style it will be foreach (var c in db.CourseEnrollments.Where(e => e.ProgramRegistration.ProgramId == id). They are equal.

Collectives™ on Stack Overflow

Using LINQ to delete multiple rows in table using matching key from related table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related