Cache Database Dependency

Nowadays, most applications that heavily use database/data source calls incorporate distributed caching to the cache-expensive query result set, which helps to boost application performance and scalability. For this purpose, any data changes in the data source should be invalidated and removed from the cache. NCache provides a mechanism, called database dependency to invalidate data when changes occur in real-time.

Moreover, these databases/data sources use relational models, but there are no relational models in caches where data exists simply as key-value pairs. To overcome this, NCache, along with database dependency offers various techniques letting users to provide dependencies of singular items on others and vice versa.

In This Section

SQL Dependency
Explains how to use the SQL database dependency feature to synchronize cache with Microsoft SQL Server 2005/2008.

Oracle Dependency
Explains how to use the Oracle dependency feature to synchronize the cache with the Oracle database.

OleDB Dependency
Depicts how you can use extensible dependencies by defining your own custom expiration logic on any database.

CLR Procedures in SQL Server
Explains how to write the CLR stored procedures for the database to synchronize caches with the database.