| Tracking and No Tracking in Entity Framework Core
|
Showing posts with label Tracking. Show all posts
Showing posts with label Tracking. Show all posts
Friday, April 3, 2020
Tracking vs No-Tracking queries
Entities retrieved using
Entity Framework Core LINQ queries
have tracking enabled by default, this allows us to make changes to the entity
and save them back to the database using SaveChanges.
Tracking can be disabled at a query level by adding AsNoTracking extension method to the query. For queries which retrieve large amount of read-only data it is recommended to disable tracking to improve performance. Disabling tracking helps us to gain some performance and also save on memory since we don’t have to save tracking information in the cache.
To disable tracking at the context level we need to set NoTracking to the QueryTrackingBehavior property as follows.
Tracking can be disabled at a query level by adding AsNoTracking extension method to the query. For queries which retrieve large amount of read-only data it is recommended to disable tracking to improve performance. Disabling tracking helps us to gain some performance and also save on memory since we don’t have to save tracking information in the cache.
To disable tracking at the context level we need to set NoTracking to the QueryTrackingBehavior property as follows.
Subscribe to:
Posts (Atom)
