Entity Framework (Core) 7 will support bulk updates and deletes meaning we won’t have to load entities into memory first which should provide a big performance boost for many apps.
Previously to achieve this developers had to use third party extensions or bypass Entity Framework and execute raw SQL using code similar to…
context.Database.ExecuteSqlRaw(“UPDATE [Employees] SET [Salary] = [Salary] + 1000”);
This functionality will be exposed via new BulkDelete() and BulkUpdate() methods. Some examples from the GitHub issue are below…
