How to delete multiple records in enitity framework without looping using LINQ?

Question

Hi I want to delete multiple records in enitity framework without using a for loop or any other loop using LINQ. Something that we can do it in SQL is there any way to delete multiple records in enitity framework

Answer 1

What you want to do is not supported using Entity Framework. Entity Framework needs to load an object into memory, before you can delete it. This way it can do its optimistic concurrency checks.

If you really need this, you will have to do this with pure SQL or better, use a stored procedure. You can call your stored procedure with Entity Framework.

Answer 2

This link may help you: Bulk Delete with EF4