Query IncludeFilter with AsNoTracking

[tojo4]

Hi all,

we are trying to use the Query IncludeFilter feature on a query with the AsNoTracking attribute. We noticed that all of the navigation properties, which are supposed to be included, are null.

Is this a known issue, and is there any workaround we can use?

Regards,
Tom

[zzzprojects]

Unfortunately, our library transforms the query to an anonymous type

From

ctx.Association_OneToMany_Lefts
     .IncludeFilter(x => x.Rights.OrderByDescending(y => y.ID))
     .AsNoTracking().ToList();

To

ctx.Association_OneToMany_Lefts
    .Select(x => new {x, x.Rights})
    .AsNoTracking().ToList();

To add relation included (in both example) automatically, the ChangeTracking must be enabled.

We will check this weekend if we can find a workaround. I believe the only possible solution will be to create a new context and use the change tracker within it when we found the "AsNoTracking" method is used. So the passed context will not be impacted by the performance and will not track entities returned either.

[andrew-lis]

I suggest to make a warning on IncludeFilter wiki page, that it doesn't work currently with AsNoTracking. I've spent 1 hour fighting with this...

[JonathanMagnan]

Hello @andrew-lis ,

Yes, you are right. Sorry for the time you lost ;(

The Wiki has been updated.

Best Regards,

Jonathan