Entity Framework Tracking vs. No-Tracking Tracking and projections
Example
- Even if the result type of the query isn’t an entity type, if the
result
contains entitytypes they will still betracked by default
Example :
-
In the following query, which returns an
anonymous type, the instances ofBookin the result setwill be trackedusing (var context = new BookContext()) { var book = context.Books.Select(b => new { Book = b, Authors = b.Authors.Count() }); } -
If the result set
does notcontain anyentitytypes, thenno trackingis performed
Example :
-
In the following query, which returns an
anonymous typewith some of the values from the entity (butno instancesof the actualentitytype), there is no tracking performed.using (var context = new BookContext()) { var book = context.Books.Select(b => new { Id = b.BookId, PublishedDate = b.Date }); }
