AsNoTracking using a insert query

Accepted 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

+3

Rajesh Gami4y ago

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.

+1

Rijwan Ansari5y ago

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

+1

Jignesh Kumar5y ago

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

+2