How to write best linq for sql query c #

Question

How can I write a request so that foreach will not use. My current request:

IEnumerable<GuestRSVP> guestrsvps = db.GuestRSVPs.Where(p => p.CeremonyGuestPartyId == CeremonyGuestpartyId); foreach (var grsvp in guestrsvps) { db.GuestRSVPs.DeleteObject(grsvp); } 

How can I delete all objects in a single request without using a foreach loop?

Answer 1

 var guestrsvps = db.GuestRSVPs .Where(p => p.CeremonyGuestPartyId == CeremonyGuestpartyId); db.GuestRSVPs.DeleteAllOnSubmit(guestrsvps); db.SubmitChanges(); 

Answer 2

Try using the Delete method and pass the lambda predicate. The snippet should look like this:

 db.GuestRSVPs.Delete(p => p.CeremonyGuestPartyId == CeremonyGuestpartyId); 

LINQ to SQL Extension: Batch Deletion with Lambda Expression