AsNoTracking using a insert query

Question

Hi, I am in new in LINQ query so my question is can we use AsNoTracking in insert statement?if yes give me the example.

Satya Karki · Answer

Hi Arshad, AsNo Tracking is generally use in read only scenario i.e. simply we can say get method(select statement). It executes fast beecause it doesnot need change tracking information. In insert query, we don't need No Tracking. Please check below link for detail understanding. https://docs.microsoft.com/en-us/ef/core/querying/tracking

Rijwan Ansari · Answer

Hi, We use AsNoTracking in query ie normally to read/select because your entities will not be track by the context. I don't see any use of AsNoTracking in insert statement. Check this for more information. https://stackoverflow.com/questions/12211680/what-difference-does-asnotracking-make Regards Rijwan

Jignesh Kumar · Answer

Hi Arshad, Please refer this link, Its not good proactices to use AsNoTracking while insert, Please refer this link, https://docs.microsoft.com/en-us/ef/core/querying/tracking https://entityframework.net/as-no-tracking

Rajesh Gami · Answer

We don't need AsNoTracking insert query, However, if you return a large amount of entities, then you think about using the AsNoTracking method whenever you do a read operation to disconnect those entities.

AsNoTracking using a insert query

Answers (4)