Hi Im struggling to get this to work as required.
I have my cache strategy set to all and the L2 cache enabled.
I currently have a scope that is attached to the HttpContext of each request, this is used for updated.
I also have a static scope that is used for reading objects only (ii added this since you said it needs to still be alive).
My query selects from the static scope like this.
return from o in MyStaticExtent where
o.Role.AspnetUsers.Any(m=>m.UserName ==userName )==
true &&
o.AccessControlKey.ResourceKey ==key
select o;
However,
I would expect the query to run once to the database and select all since my cache strategy is set to 'all', however it passes the where on to the database and calls the db for each subsequent request with a different parameter ...
How does the cache strategy work, and is it something im doing (the join maybe ?) that is preventing it from working as required...
Thanks