SQL Query in Cache

Note

This feature is only available in NCache Enterprise Edition.

NCache provides a faster and an efficient quering mechanism that lets you query your cache according to the given criteria and obtain the result set. Various ways to query caches according to SQL queries are explained in the successive chapters.

In This Section

SQL Query Behavior Overview
Discusses the basic overview of querying cache with SQL along with the topology wise behavior.

Define Indexes Programmatically
Discusses how to define indexes programmatically.

Query Data in Cache Using SQL
Discusses how to query the cache using SQL and use other SQL operations supported by NCache.

Delete Data with ExecuteNonQuery
Discusses how to delete the items from the cache using an SQL-like format.

SQL Reference for NCache
Explains the SQL syntax and all the query formats supported by NCache.