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.)