Bulk-deleting in LINQ to Entities

by

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

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. ‘Contains()’ workaround using Linq to Entities?
  4. “A lambda expression with a statement body cannot be converted to an expression tree”
  5. The type of one of the expressions in the join clause is incorrect in Entity Framework
  6. Entity framework left join
  7. LEFT JOIN in LINQ to entities?
  8. How to compare only date components from DateTime in EF?
  9. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  10. Linq to Entity Join table with multiple OR conditions
  11. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  12. Dynamic query with OR conditions in Entity Framework
  13. Calling a SQL User-defined function in a LINQ query
  14. Check if list contains item from other list in EntityFramework
  15. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  16. Method cannot be translated into a store expression
  17. How to use a string to create a EF order by expression?
  18. How to disable cascade delete for link tables in EF code-first?
  19. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  20. Dynamic table name in linq [duplicate]
  21. Linq Syntax – Selecting multiple columns
  22. Join and Include in Entity Framework
  23. Creating dynamic queries with entity framework
  24. Log Queries executed by Entity Framework DbContext
  25. Remove item from list based on condition
  26. How to group by DateTime.Date in EntityFramework
  27. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  28. How to include() nested child entity in linq
  29. Only parameterless constructors and initializers are supported in LINQ to Entities message
  30. LINQ Query to Convert string to datetime

Leave a Comment