Method ExecuteReader
ExecuteReader(String, IDictionary)
Performs search on the Cache based on the query specified where query contains 'group by' clause.
Declaration
public override ICacheReader ExecuteReader(string query, IDictionary values)
Parameters
Type |
Name |
Description |
System.String |
query |
simple SQL like query syntax to query objects from cache
|
System.Collections.IDictionary |
values |
The IDictionary of atribute names and values.
|
Returns
Type |
Description |
ICacheReader |
Returns a cache data reader ICacheReader
|
Overrides
Examples
These operators are supported by NCache Queries.
- Comparison Operators = , == , != , <> , < , > , <=, >=, IN
- Logical Operators AND , OR , NOT
- Miscellaneous () , DateTime.Now , DateTime("any date time compatible string")
Cache _cache = NCache.InitializeCache("myCache");
Hashtable values = new Hashtable();
values.Add("Name", "Paul Jones");
string query="select Test.Application.Employee where this.Name = ?";
ICacheReader result=_cache.ExecuteReader(query,values);
values.Clear();
values.Add("Salary", 2000);
query="select Test.Application.Employee where this.Salary > ?";
result=_cache.ExecuteReader(query,values);
values.Clear();
values.Add("Name", "Paul jones");
values.Add("Salary", 2000);
query="select Test.Application.Employee where this.Name = ? and this.Salary > ?";
result=_cache.ExecuteReader(query,values);
values.Clear();
values.Add("Name", "Paul Jones");
values.Add("Salary", 2000);
query="select Test.Application.Employee where Not(this.Name = 'Paul Jones' and this.Salary > 2000)";
result=_cache.ExecuteReader(query,values);
ExecuteReader(String, IDictionary, Boolean)
Declaration
public override ICacheReader ExecuteReader(string query, IDictionary values, bool getData)
Parameters
Type |
Name |
Description |
System.String |
query |
|
System.Collections.IDictionary |
values |
|
System.Boolean |
getData |
|
Returns
Overrides
ExecuteReader(String, IDictionary, Boolean, Int32)
Declaration
public override ICacheReader ExecuteReader(string query, IDictionary values, bool getData, int chunkSize)
Parameters
Type |
Name |
Description |
System.String |
query |
|
System.Collections.IDictionary |
values |
|
System.Boolean |
getData |
|
System.Int32 |
chunkSize |
|
Returns
Overrides