Modifying Data with EF Core: More Efficient Updates and Deletes

Learn about data modification in EF Core and explore ExecuteUpdate and ExecuteDelete techniques.

We'll cover the following...

The traditional way to modify data with EF Core

The traditional way of modifying data using EF Core is summarized in the following steps:

Create a database context. Change tracking is enabled by default.
To insert, create a new instance of an entity class and then pass it as an argument to the Add method of the appropriate collection, for example, db.Products.Add(product).
To update, retrieve the entities we want to modify and then change their properties.
To delete, retrieve the entities we want to remove and then pass them as an argument to the Remove or RemoveRange methods of the appropriate collection, for example, db.Products.Remove(product).
Call the SaveChanges method of the database context. This uses the change tracker to generate SQL statements to perform the needed inserts, updates, and deletes, then returns the number of entities affected. ...