ConnectionHelperExecuteQuery Method (String, QueryDataParameters, String, String, Int32, String) |
Executes query and returns result as a dataset.
Namespace: CMS.DataEngineAssembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 12.0.0
Syntaxpublic static DataSet ExecuteQuery(
string queryName,
QueryDataParameters parameters,
string where = null,
string orderBy = null,
int topN = 0,
string columns = null
)
Parameters
- queryName
- Type: SystemString
Name of the query in format application.class.queryname - parameters
- Type: CMS.DataEngineQueryDataParameters
Query parameters - where (Optional)
- Type: SystemString
WHERE expression - orderBy (Optional)
- Type: SystemString
Sort expression - topN (Optional)
- Type: SystemInt32
Top N expression - columns (Optional)
- Type: SystemString
Columns expression
Return Value
Type:
DataSet
See Also