How to write a better linq to sql query c#

Question

How i can write a query , so that foreach will not use. My current query is :

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

How i can delete all objects in a single query, without using foreach loop ?

Have a look at this: stackoverflow.com/questions/654561/linq-to-sql-batch-delete — Allov
– Allov, Commented Aug 15, 2012 at 13:35
I think this SO question will help you stackoverflow.com/questions/853526/… — juan.facorro
– juan.facorro, Commented Aug 15, 2012 at 13:36

Timothy S. Van Haren · Accepted Answer · 2012-08-15 13:35:02Z

6

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

db.GuestRSVPs.DeleteAllOnSubmit(guestrsvps);
db.SubmitChanges();

answered Aug 15, 2012 at 13:35

Timothy S. Van Haren

8,9762 gold badges32 silver badges34 bronze badges

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

Comments

Ilya Ivanov · Accepted Answer · 2012-08-15 13:41:51Z

0

Try to use Delete method and pass lambda predicate into. Snippet should look like:

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

LINQ to SQL Extension: Batch Deletion with Lambda Expression

answered Aug 15, 2012 at 13:41

Ilya Ivanov

23.7k4 gold badges69 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to write a better linq to sql query c#

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related