Entity framework `AsNoTracking` is not working with anonymous projection

Question

In the below snipped i try to fetch data using Anonymous Projection and i would like do not track the entities that is fetched.

Note : i have already gone through existing stack question,yet unable to find a working solution for me

using (var db = new Entities())
{
     db.Configuration.LazyLoadingEnabled = false;
     db.Configuration.ProxyCreationEnabled = false;

     var myprojection = db.Table1
                        .AsNoTracking()
                        .Include(gh=>gh.Table2) //Update
                        .Include(gh=>gh.Table3) //Update
                        .Select(x => new
                        {
                            table1= x,
                            table2= x.Table2.Where(g => Some Condition),

                            table3= x.Table3.Where(g=>Some Condition)
                        })
                        .ToList();

    var result = myprojection.Select(g =>g.table1).FirstOrDefault();

}

When i useAsNoTracking() data from the inner tables (table2,3) is lost during the conversion at this line var result = myprojection.Select(g =>g.table1).FirstOrDefault();

Edit

If i remove AsNoTracking() everything works fine.

1) How to use projection and AsNoTracking in entity framework correctly ?

2) Any other option to remove tracking of this query?

Is there any possible workarounds?

Answer 1

Use ToList() for your navigation properties. Note that it will still projekt in the DB. (EF6)

// ..
table2 = x.Table2.Where(g => Some Condition).ToList(),

Update:

With EF4 you probably need to map table2 manually:

 table2 = x.Table2.Where(g => CONDITION).Select(x => new {Foo = x.Bar}),