Entity Framework 7 will support bulk updates and deletes

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…

 

Leave a Reply

Your email address will not be published.