SQL and LINQ Queries

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 sections.

LINQ allows to query and filter information from multiple data sources, such as relational databases, XML, ADO.NET DataSet, and more, it is particularly useful with NCache. As you can add to the existing advantages of NCache with increased application performance and facilitate the execution of LINQ queries over the distributed cache.

NCache supports querying with both SQL and LINQ.

In This Section

Indexes
This page explains how to index any searchable object and its fields in NCache.

SQL Language Support
This page explains how to use SQL queries in NCache.

LINQ Language Support
This page explains how to use LINQ queries to filter information from multiple data sources.