var location = dbContext.Location .Where(l => l.Location.ID == location_ID) .SingleOrDefault(); return location;
Since the above code is simply returning an entity without modifying or adding it, we can avoid tracking cost.
var location = dbContext.Location.AsNoTracking() .Where(l => l.Location.ID == location_ID) .SingleOrDefault(); return location;
When we use function
AsNoTracking() we are explicitly telling Entity Framework that the entities are not tracked by the context. This can be especially useful when retrieving large amounts of data from your data store. If you want to make changes to un-tracked entities however, you must remember to attach them before calling