3

how to configure second level cache in code (not thru xml)

the current settings i have are:

 public NHCachingSetup(Configuration cfg)
        {
            // use first level cache
            cfg.Cache(x =>
            {
                x.UseQueryCache = true;
                x.Provider<SysCacheProvider>();
            });

            // set 60 min expiration time
            cfg.SessionFactory().Caching
                .WithDefaultExpiration(60);
        }

2 Answers2

3

The way I have done this with NH 3.3 is like

var configure = new Configuration();
...
configure.Cache(x => x.UseQueryCache = true)
...
configure.SessionFactory().Caching
  .Through<SysCacheProvider>().WithDefaultExpiration(1440);//secs!

edit in your mapping you will need:-

Cache(x => x.Usage(CacheUsage.ReadOnly));

end edit

Then to use you can do something like (this caches a lookup table for me):-

Db.Query<SpamAssassin>().Cacheable().CacheMode(CacheMode.Normal).ToList();
Rippo
  • 22,117
  • 14
  • 78
  • 117
  • but there in no L2 cache configuration... i m not able to enable L2 cache in the first place... –  Mar 19 '13 at 19:23
  • Sorry I don't understand your comment. You enable it from the code I have provided. – Rippo Mar 19 '13 at 21:01
  • .SetProperty(Environment.UseSecondLevelCache, "true"), is what was missing –  Mar 20 '13 at 05:26
  • 1
    You can also do it the way I have shown, your way is the old way of setting it. – Rippo Mar 21 '13 at 11:01
0

got it:

cfg.SetProperty(Environment.BatchSize, "100")
                .SetProperty(Environment.UseQueryCache, "true")
                .SetProperty(Environment.UseSecondLevelCache, "true")
                .Cache(x => { x.Provider<SysCacheProvider>(); });