What is the use of AsNoTracking() in EF Core?

AsNoTracking() flags the framework to not to track changes on the records returned. EF Core then doesn't persist the result, thus conserving memory.

When querying for records from an EntitySet using Entity Framework Core, it persists the state of the records returned and keeps track of any changes that are applied on the records.

AsNoTracking() is an extension method that flags the framework to not to track changes on the records returned.

Entity Framework Core then doesn’t persist the result, thus conserving memory.

Example –

var result = _db.MyEntities.AsNoTracking()
.Where(x => x.IsActive == true).First();

// result returned now is not tracked and 
// so whatever changes are applied, can't be saved

When to use?

It is useful for cases involving read-only queries where no data is overwritten via the records. Use it when you don’t require the entities returned by your query need to be tracked and updated back to database.

Ram
Ram

I'm a full-stack developer and a software enthusiast who likes to play around with cloud and tech stack out of curiosity. You can connect with me on Medium, Twitter or LinkedIn.

Privacy Overview
Referbruv

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

3rd Party Cookies

This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.

Keeping this cookie enabled helps us to improve our website.