1. How to work first-level cache? I`m in one session execute identical query , but in MSSQL evry time execute many queryes.
2. How add in NHibernate configuration second-level cache. I have all need DLL`s. In help say To tells which cache provider to use, add in your NHibernate configuration file (can be YourAssembly.exe.config or web.config or a .cfg.xml file):

<add key="hibernate.cache.provider_class" value="XXX" />(1)
<add key="relativeExpiration" value="120" />(2)
but it`s not work.[/code]

1. It is the Query Cache...
2. What doesn't work?

You may read this: Hibernate: Truly Understanding the Second-Level and Query Caches

Thanks it`s very cool reference. My problem with the second-level cache:
1. I can`t attach second-level in my prodject? if paste this strings
<add key="hibernate.cache.provider_class" value="XXX" />(1)
<add key="relativeExpiration" value="120" /> in the hibernate.cfg.xml, im recive Exseption
System.ApplicationException problem parsing configuration : System.Xml.Schema.XmlSchemaException: The element 'urn:nhibernate-configuration-2.0:hibernate-configuration' has invalid child element 'urn:nhibernate-configuration-2.0:add'. An error occurred at file:///C:/nHibernate/TestC#/GarageManager/bin/Debug/hibernate.cfg.xml, (16, 3). what`s wrong?
2. How correctly attach second-level?

Use this syntax:


Also, you have to enable the query cache by setting hibernate.cache.use_query_cache to true.