/// <summary>
/// This method queries items in the cache on which index was defined using NCache Manager.
/// </summary>
private static void QueryItemsUsingDefinedIndex()
{
// Query can only be applied to C# Primitive data types:
// and for those non primitive data types whose indexes are defined in NCache manager
string query = "SELECT $Value$ FROM Alachisoft.NCache.Sample.Data.Product WHERE UnitPrice > ?";
QueryCommand queryCommand = new QueryCommand(query);
queryCommand.Parameters.Add("UnitPrice", Convert.ToDecimal(100));
ICacheReader reader = _cache.SearchService.ExecuteReader(queryCommand);
int counter = 0;
if (reader.FieldCount > 0)
{
while (reader.Read())
{
var product = reader.GetValue <Product>(1);
PrintProductDetails(product);
counter++;
}
}
Console.WriteLine("{0} cache items fetched from cache using query on unit price.\n", counter);
}
/// <summary>
/// This method queries cached data
/// </summary>
/// <param name="customer"> Instance of registered continuous query to query cached items</param>
private static void QueryDataInCache(ContinuousQuery continuousQuery)
{
// Getting key-value pair via query
// Much faster way ... avoids round trip to cache
ICacheReader cacheReader = _cache.ExecuteReaderCQ(continuousQuery, true);
if (!cacheReader.IsClosed)
{
// Print output on console
Console.WriteLine("\nFollowing items are fetched with Continuous Query.");
while (cacheReader.Read())
{
var asd = cacheReader[0];
Customer customerFound = (Customer)cacheReader[1];
PrintCustomerDetails(customerFound);
}
}
}
/// <summary>
/// This method fetches items from the cache using named tags.
/// </summary>
private static void GetItems()
{
string query = "SELECT Alachisoft.NCache.Sample.Data.Order WHERE this.Category = ? AND this.ProductName = ?";
QueryCommand itemQuery = new QueryCommand(query);
itemQuery.Parameters.Add("Category", "Beverages");
itemQuery.Parameters.Add("ProductName", "Coke");
ICacheReader result = _cache.SearchService.ExecuteReader(itemQuery, true);
if (!result.IsClosed)
{
while (result.Read())
{
Console.WriteLine(result.GetString(0));
}
}
}
/// <summary>
/// This method fetches items from the cache using named tags.
/// </summary>
private static void GetItems()
{
string query = "SELECT Alachisoft.NCache.Sample.Data.Order WHERE this.Category = ? AND this.ProductName = ?";
Hashtable values = new Hashtable();
values["Category"] = "Beverages";
values["ProductName"] = "Coke";
ICacheReader result = _cache.ExecuteReader(query, values);
if (!result.IsClosed)
{
while (result.Read())
{
Console.WriteLine(result[0].ToString());
}
}
}
/// <summary>
/// This method queries cached data
/// </summary>
/// <param name="customer"> Instance of registered continuous query to query cached items</param>
private static void QueryDataInCache(QueryCommand queryCommand)
{
// Getting keyvalue pair via query
// Much faster way ... avoids round trip to cache
//ICacheReader cacheReader = _cache.ExecuteReaderCQ(continuousQuery, true);
ICacheReader cacheReader = _cache.SearchService.ExecuteReader(queryCommand, true);
if (!cacheReader.IsClosed)
{
// Print output on console
Console.WriteLine("\nFollowing items are fetched with Continuous Query.");
while (cacheReader.Read())
{
var asd = cacheReader.GetValue <object>(0);
Customer customerFound = cacheReader.GetValue <Customer>(1);
PrintCustomerDetails(customerFound);
}
}
}
/// <summary>
/// This method queries cached keys
/// </summary>
/// <param name="customer"> Instance of registered continuous query to query cached items</param>
private static void QueryKeysInCache(ContinuousQuery continuousQuery)
{
// Getting keys via query
ICacheReader cacheReader = _cache.ExecuteReaderCQ(continuousQuery, false);
if (!cacheReader.IsClosed)
{
// Print output on console
Console.WriteLine("\nFollowing keys are fetched with Continuous Query.");
while (cacheReader.Read())
{
string key = (string)cacheReader[0];
Console.WriteLine("Key: " + key);
// A second call to cache to fetch the customer
//Customer cachedCustomer = (Customer)_cache.Get(key);
}
}
}
/// <summary>
/// This method queries items from the cache using both named tags and pre-defined index.
/// </summary>
private static void QueryItemsUsingNamedTagsAndIndex()
{
string query = "SELECT Alachisoft.NCache.Sample.Data.Product Where this.ProductName = ?";
var criteria = new Hashtable();
criteria["ProductName"] = "HTCPhone";
ICacheReader result = _cache.ExecuteReader(query, criteria);
if (!result.IsClosed)
{
while (result.Read())
{
Product productFound = (Product)result[1];
PrintProductDetails(productFound);
}
}
Console.WriteLine();
}
/// <summary>
/// This method queries Items from NCache using named tags.
/// </summary>
private static void QueryItemsUsingNamedTags()
{
// Defining Searching criteria
Hashtable criteria = new Hashtable();
criteria["Employee"] = "DavidBrown";
string query = "SELECT System.String WHERE this.Employee = ?";
ICacheReader result = _cache.ExecuteReader(query, criteria);
if (!result.IsClosed)
{
while (result.Read())
{
Console.WriteLine(result[0].ToString());
}
}
Console.WriteLine();
}
/// <summary>
/// This method queries cached keys
/// </summary>
/// <param name="customer"> Instance of Query Command to query cached items</param>
private static void QueryKeysInCache(QueryCommand queryCommand)
{
// Getting keys via query
//ICacheReader cacheReader = _cache.ExecuteReaderCQ(continuousQuery, false);
ICacheReader cacheReader = _cache.SearchService.ExecuteReader(queryCommand, false);
if (!cacheReader.IsClosed)
{
// Print output on console
Console.WriteLine("\nFollowing keys are fetched with Continuous Query.");
while (cacheReader.Read())
{
string key = cacheReader.GetValue <string>(0);
Console.WriteLine("Key: " + key);
// A second call to cache to fetch the customer
//Customer cachedCustomer = (Customer)_cache.Get(key);
}
}
}
/// <summary>
/// This method queries Items from NCache using named tags.
/// </summary>
private static void QueryItemsUsingNamedTags()
{
string query = "SELECT $Value$ FROM Alachisoft.NCache.Sample.Data.Product WHERE Supplier = ?";
QueryCommand queryCommand = new QueryCommand(query);
// Defining Searching criteria
queryCommand.Parameters.Add("Supplier", "Tokyo Traders");
ICacheReader reader = _cache.SearchService.ExecuteReader(queryCommand);
int counter = 0;
if (reader.FieldCount > 0)
{
while (reader.Read())
{
var product = reader.GetValue <Product>(1);
PrintProductDetails(product);
counter++;
}
}
Console.WriteLine("{0} cache items fetched from cache using query on named tags.\n", counter);
}
/// <summary>
/// This method queries items in the cache on which index was defined using NCache Manager.
/// </summary>
private static void QueryItemsUsingPreDefinedIndex()
{
// Query can only be applied to C# Primitive data types:
// and for those non primitive data types whose indexes are defined in NCache manager
string query = "SELECT Alachisoft.NCache.Sample.Data.Product Where this.Id = ?";
var criteria = new Hashtable();
criteria["Id"] = 1;
ICacheReader result = _cache.ExecuteReader(query, criteria);
if (!result.IsClosed)
{
while (result.Read())
{
Product productFound = (Product)result[1];
PrintProductDetails(productFound);
}
}
Console.WriteLine();
}
/// <summary>
/// This method queries items from the cache using projection attributes.
/// </summary>
private static void QueryItemsUsingProjection()
{
string query = "SELECT Name, Supplier FROM Alachisoft.NCache.Sample.Data.Product WHERE UnitPrice > ?";
QueryCommand queryCommand = new QueryCommand(query);
queryCommand.Parameters.Add("UnitPrice", Convert.ToDecimal(100));
ICacheReader reader = _cache.SearchService.ExecuteReader(queryCommand);
int counter = 0;
if (reader.FieldCount > 0)
{
while (reader.Read())
{
Console.WriteLine("Name: " + reader.GetValue <string>("Name"));
Console.WriteLine("Supplier: " + reader.GetValue <string>("Supplier"));
Console.WriteLine();
counter++;
}
}
Console.WriteLine("{0} cache items fetched from cache using projection query on unit price.\n", counter);
}
public bool MoveNext()
{
return(reader.Read());
}