Use of AsNoTracking().

Question

Hello every one I'm new in .net core with ef .What is use AsNoTracking() in get list .Please explian me in simple defination.

Sachin Singh · Answer

Its very depth concept, the EF context keeps track of changes like when you add something to the dbset then state becomes added similarly if you delete something from DbSet then the state becomes deleted now when you call SaveChanges() based on the state only EF fires necessary T-SQL and your changes commits to the database. If you use NoTracking it means you are telling EF to don't track anything whatever change i will do on my DbSet so when you will call SaveChanges() nothing will be commited to database. If you don't need to update the entities retrieved from the database, then a no-tracking query should be used. After below code anychange to the Employees will not reflect in database. var emps= context.Employees .AsNoTracking() .ToList();

Harsh Shah · Answer

AsNoTracking() returns a Context or a new query where entities will not catch in the DbContext, which means that does not have tracking and quires will read from the Database origin but would not save in context. Please refer to this https://www.c-sharpcorner.com/UploadFile/ff2f08/entity-framework-and-asnotracking/#:~:text=The%20AsNoTracking()%20extension%20method,are%20returned%20by%20the%20query.

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/ff2f08/entity-framework-and-asnotracking/