Hi all,

I need to improve the performance of a web application, so I resolved to enable the second level cache of NHibernate to do this.

In my first try the cache simply does not works, looking the SQL Server Profiler I saw that the NHibernate go to database everytime.

Reading the Documentation of NHibernate I solved this problem calling the method "IQuery.SetCacheable(true)".

Now the NHibernate go to database only once, but in the second call to that entity, all values are NULL!!!!!!!!!!!!!

Whats wrong??????

I tried with SysCache and Bamboo.Prevalence and the samething happens.

My NHibernate version is 1.0.3

Nobody can help me???

Now, I changed the NHibernate version to 1.2.0 and without sucess!!!

I tried all caches but nothing happens!!!!!

Help me please! It's too urgent!!!

Did you try configuring cache regions?

<configSections>
<section name="syscache" type="NHibernate.Caches.SysCache.SysCacheSectionHandler, NHibernate.Caches.SysCache"/>
</configSections>
<syscache>
<cache region="blah" expiration="1000" priority="5"/>
</syscache>

Then call IQury.SetCacheRegion("blah")?

Not, I'll try now!!!!

P.S. The "HashtableCacheProvider" works fine.

You shouldn't use that for a production based system. It may cause more problems then fixing them.

Read the documentation on it.

Great!!!!!!

Now the second level cache is working.

I think that is a bug.

About the HashtableCacheProvider, I know that isn't for production purposes.

Thanks!!!!