Configuring Database Synchronization with NHibernate

NCache provides database synchronization where cache keeps track of database changes and either invalidates a cached item or reloads it if its corresponding data changes in the database.

You can configure NHibernate Second Level Cache provider for NCache to use database synchronization. Just modify NCacheNHibernate.xml configuration file as following:

 <configuration>
   <application-config application-id="myapp" enable-cache-exception="true" default-region-name="default" key-case-sensitivity="false">

    <database-dependencies>
      <dependency entity-name="nhibernator.BLL.Customer" type="sql" sql-statement="SELECT ContactName FROM dbo.Customers WHERE CustomerID =?" cache-key-format="depdency.customer:[us]"/>
    </database-dependencies>

  </application-config>
 </configuration>