Bulk-deleting in LINQ to Entities
A while back I wrote a 4 part blog series (Parts 1, 2, 3 and 4) covering doing bulk updates (with one command) in the Entity Framework.
While the focus of that series was update, you could definitely use the principles involved to do delete.
So you should be able to write something like this:
var query = from c in ctx.Customers where c.SalesPerson.Email == "..." select c;query.Delete();All you need to do is implement the Delete() extension method. See the post series for hints on how...
Hope this helps
using (var context = new DatabaseEntities()) { // delete existing records context.ExecuteStoreCommand("DELETE FROM YOURTABLE WHERE CustomerID = {0}", customerId); }
The question is an old one (from before EF5 existed). For anyone who's using EF5, EntityFramework.Extended does this in a snap.