SQL Query in Cache

NCache provides a faster and an efficient querying 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 Overview
Discusses the basic overview of querying cache with SQL along with the topology-wise behavior.

Define Indexes Programmatically
Discusses how to define SQL indexes programmatically with ease.

Query Data in Cache Using SQL
Discusses how to query the cache using SQL and 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
Explains the SQL syntax and all the query formats supported by NCache.