Synchronize Database with NHIbernate Second Level Cache

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>

See Also

Using NCache as NHibernate Second Level Cache
Using NHibernate Query Caching
Entity Framework Cache Provider
AppFabric to NCache Migration