SQL Query in Cache

NCache provides an efficient querying mechanism that lets you retrieve cached data based on specified 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 Execute Reader, Execute Scalar, and other SQL operations supported by NCache.

Delete Data with ExecuteNonQuery
Discusses how to delete the items from the cache using an ExecuteNonQuery.

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