Wednesday, 14 August 2013

Scope of AsNoTracking() within LINQ query in Entity Framework

Scope of AsNoTracking() within LINQ query in Entity Framework

When using AsNoTracking() within a LINQ query in Entity Framework, should
I be using it against each individual table or the query as a whole?
1. Against the entire query
var query = (from t1 in db.Table1
from t2 in db.Table2.Where(o => t1.ConditionId == o.ConditionId)
select t1).AsNoTracking()
2. Against each table
var query = (from t1 in db.Table1.AsNoTracking()
from t2 in db.Table2.AsNoTracking().Where(o => t1.ConditionId
== o.ConditionId)
select t1)

No comments:

Post a Comment