AsNoTracking

Compatible with:

• EF Core
• EF6

The AsNoTracking feature applies this method to the resulting query executed by EF6 or EF Core.

No tracking queries are useful when the results are used in a read-only scenario. They’re quicker to execute because there’s no need to set up the change tracking information. If you don’t need to update the entities retrieved from the database, then a no-tracking query should be used.

Example

The following example shows how to add AsNoTracking to a specification:

public class CustomerByNameReadOnlySpec : Specification<Customer>
{
  public CustomerByNameReadOnlySpec(string name)
  {
    Query.Where(x => x.Name == name)
      .AsNoTracking()
      .OrderBy(x => x.Name)
        .ThenByDescending(x => x.Address);
    }
}

Note: It’s a good idea to note when specifications use AsNoTracking so that consumers of the specification will not attempt to modify and save entities returned by queries using the specification. The above specification adds ReadOnly to its name for this purpose.