Synchronize Database with Second-level NHibernate Cache
NCache ensures data integrity for NHibernate applications by providing real-time database synchronization. This mechanism allows the NHibernate Second-level Cache to monitor changes in the underlying database, automatically invalidating or reloading cached entities when data is modified.
Configure NHibernate Second-level Cache Provider
You can configure NHibernate Second-level Cache Provider for NCache to use database synchronization. Just modify NCacheNHibernate.xml configuration file as follows:
<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