How do I delete multiple rows in Entity Framework (without foreach)

by

EntityFramework 6 has made this a bit easier with .RemoveRange().

Example:

db.People.RemoveRange(db.People.Where(x => x.State == "CA"));
db.SaveChanges();

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. Entity Framework: “Store update, insert, or delete statement affected an unexpected number of rows (0).” [closed]
  3. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  4. Disable lazy loading by default in Entity Framework 4
  5. Best way to check if object exists in Entity Framework? [closed]
  6. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  7. EF5 Code First Enums and Lookup Tables
  8. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  9. Entity Framework One-To-One Mapping Issues
  10. How can I delete 1,000 rows with EF6?
  11. Entity Framework 4 selective lazy loading properties
  12. When should I call SaveChanges() when creating 1000’s of Entity Framework objects? (like during an import)
  13. Adding Validation Attributes With an Entity Framework Data Model
  14. How to exclude one table from automatic code first migrations in the Entity Framework?
  15. Ramifications of DbSet.Create versus new Entity()
  16. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  17. Entity Framework : How do you refresh the model when the db changes?
  18. Entity framework code first creates “discriminator” column
  19. EF Migrations: Rollback last applied migration?
  20. Using EF Core ThenInclude() on Junction tables
  21. How to update not every fields of an object using Entity Framework and EntityState.Modified
  22. What is the best practice in EF Core for using parallel async calls with an Injected DbContext?
  23. EF Code First foreign key without navigation property
  24. LINQ to Entities for subtracting 2 dates
  25. Using the Entry().CurrentValues.SetValues() is not updating collections
  26. .NET 4.5 Beta DbGeography NotImplementedException
  27. Changing Inherited Types in Entity Framework
  28. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  29. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  30. Why does the entity framework need an ICollection for lazy loading?

Leave a Comment