How to enable second level cache in ActiveRecord Linq?

Question

Second level cache can be enable using QueryOptions. But how could be enabled in Castle ActiveRecord Linq? ActiveRecordLinq class does not have such a property.

Answer 1

I think QueryOptions applied only for the old Linq provider (pre NH 3). With NH 3 you have to call Cacheable() on the IQueryable<T>. I'm pretty sure you can apply the same method to an IQueryable returned by ActiveRecord.