Best way to delete multiple records in a LINQ query?

Question

What is the best way to multiple records in one go in LINQ?

Answer 1

From the blog post http://solidcoding.blogspot.com/2007/12/sql-in-clause-in-linq.html

      using (DataContext dc = new DataContext("connectionstring"))
   {
     List<string> names = new List<string>();
    names.Add("Anderson");
    names.Add("Johnson");
    List<Person> list = (from p in dc.GetTable<Person>() where names.Contains(p.LastName) select p).ToList();
  }

Answer 2

The good old SPROCs.....

You can drag the SPROC to your DBML file and it will generate a rich method in your databasecontext class.

• How to: Call a Stored Procedure by Using LINQ (Visual Basic)
• LINQ and Stored Procedures

Answer 3

To delete records with Linq2Sql

CustomerDataContext ctx = new CustomerDataContext("connection string");
Customer cust = ctx.Customers.Where(c => c.Name == "david");

ctx.Customers.DeleteAllOnSubmit(cust);
ctx.SubmitChanges();

Answer 4

The following is more for LINQ to Entities, but it may help:

http://stackoverflow.com/questions/869209/bulk-deleting-via-linq