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.
- Comparison Operators = , == , != , <> , < , > , <=, >=, IN
- Logical Operators AND , OR , NOT
- 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);