When I call the following code (SelfService), it performs two roundtrips to the database. I would expect that the second call would get its data from the cache.

CacheController.RegisterCache("", new ResultsetCache());

var metaData = new LinqMetaData();
var query = (from exampleEntity in metaData.Example
            where exampleEntity.Id == 1
            select exampleEntity.Status).CacheResultset(2);

var result1 = query.FirstOrDefault();  // Performs 1st call to database
var result2 = query.FirstOrDefault();  // Performs 2nd call to database, but shouldn't

(Id is the primary key, Status is an int column.)

This is caused by the fact the cache directive is not at the outside of the query. In your situation this is of course unavoidable, as the result of FirstOrDefault isn't an IQueryable.

Looking into it. The query is read from the cache if you do ToList instead of FirstOrDefault.

Other query types are also not working. E.g. query.Any(), query.Count(), they all don't obey the caching. We're going to log the caching directives inside they query now and merge it with the outer query, as that's the only way to make e.g. query.Any() use the caching directive as it will end up in the projection as a scalar query inside a CASE.

We've fixed it, for all these query types. Fix is attached (is also in the new build, which we'll upload within an hour or so).