Method ExecuteNonQuery

ExecuteNonQuery(QueryCommand)

Executes delete statements on cache. Returns number of affected rows after query is executed.

Declaration
int ExecuteNonQuery(QueryCommand queryCommand)
Parameters
Type Name Description
QueryCommand queryCommand

QueryCommand containing query text and values.
Returns
Type Description
System.Int32

Number of rows affected after query is executed.
Remarks

Only Delete Query is supported yet.

These operators are supported by NCache Queries.

  1. Comparison Operators = , == , != , <> , < , > , <=, >=, IN
  2. Logical Operators AND , OR , NOT
  3. Miscellaneous () , DateTime.Now , DateTime("any date time compatible string")
Examples
ICache _cache = CacheManager.GetCache("demoCache");

string query = "delete Test.Application.Employee where this.Name = ?";
QueryCommand queryCommand = new QueryCommand(query);
queryCommand.Parameters.Add("Name", "Paul Jones");
int result = _cache.SearchService.ExecuteNonQuery(queryCommand);

query = "delete Test.Application.Employee where this.Salary > ?";
queryCommand = new QueryCommand(query);
queryCommand.Parameters.Add("Salary", 2000);
result = _cache.SearchService.ExecuteNonQuery(queryCommand);

query = "delete Test.Application.Employee where Not(this.Name = 'Paul Jones' and this.Salary > 2000)";
queryCommand = new QueryCommand(query);
queryCommand.Parameters.Add("Name", "Paul Jones");
queryCommand.Parameters.Add("Salary", 2000);
result = _cache.SearchService.ExecuteNonQuery(queryCommand);