Cache Database Dependency [Deprecated]

Nowadays, most data-intensive applications use distributed caching to store costly query results, improving 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 the cached 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 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 onwards.

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

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

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