How do I delete multiple rows in Entity Framework Core? [duplicate]

by

because I get an error “InvalidOperationException: Collection was modified; enumeration operation may not execute” after the first object. In other words, .Remove removes only one object.

This has nothing to do with EF Core, and, yes, .Remove() only removes one object. However, you are attempting to modify a collection that you are iterating through. There are ways to do this, but this isn’t a good route to go.

Entity Framework Core does NOT have .RemoveRange, so I have no idea how to perform this operation.

There are definitely at least a couple simple ways to delete multiple records in EF Core. And, EF Core does have a RemoveRange() method – it’s a method on DbSet<TEntity>, see here in the API docs (as stated in the comment above).

A couple options:

  1. If myCollection is of a type that belongs to a DbSet<TEntity>, a simple call such as this will do the trick:

    _dbContext.MyEntities.RemoveRange(myCollection);
_dbContext.SaveChanges();

  2. If myCollection is actually a navigation property off of an entity that you queried, you can call .Clear() on the collection instead of iterating and calling .Remove().

    var myParentEntity = _dbContext.MyParentEntities
                         .Include(x => x.MyChildrenEntities)
                         .Single(x => x.Id == id);
myParentEntity.MyChildrenEntities.Clear();
_dbContext.SaveChanges();

As also commented above, there’s a lot of context missing on your question – more complete code should be posted. I’m just taking a couple stabs in the dark to get you up and running with EF Core!

More Related Contents:

  1. Dynamically change connection string in Asp.Net Core
  2. Many-to-many self referencing relationship
  3. navigation property should be virtual – not required in ef core?
  4. Cannot access a disposed object in ASP.NET Core when injecting DbContext
  5. How to instantiate a DbContext in EF Core
  6. auto create database in Entity Framework Core
  7. Filter all queries (trying to achieve soft delete)
  8. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  9. How to add the same column to all entities in EF Core?
  10. Unable to create migrations after upgrading to ASP.NET Core 2.0
  11. Dynamically changing schema in Entity Framework Core
  12. How to store JSON in an entity field with EF Core?
  13. Cascade deleting with EF Core
  14. EF CORE 2.1 HasConversion on all properties of type datetime
  15. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  16. Include with FromSqlRaw and stored procedure in EF Core 3.1
  17. Azure Function, EF Core, Can’t load ComponentModel.Annotations 4.2.0.0
  18. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  19. Entity framework EF.Functions.Like vs string.Contains
  20. The LINQ expression could not be translated and will be evaluated locally
  21. Avoid or control circular references in Entity Framework Core
  22. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  23. Add migration with different assembly
  24. EF models. Navigation properties can only participate in a single relationship
  25. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  26. How to load navigation properties on an IdentityUser with UserManager
  27. How to create a password protected database?
  28. Implementing recursive property loading in EF Core
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. Entity Framework Core RC2 table name pluralization

Leave a Comment