Click or drag to resize
AbstractInfoProviderTInfo, TProvider, TQueryExecuteQuery Method

Note: This API is now obsolete.

Executes query and returns result as a dataset.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0
Syntax
C#
[ObsoleteAttribute("Use member CMS.DataEngine.ConnectionHelper.ExecuteQuery(string, QueryDataParameters, string, string, int, string, int, int, ref int) instead.")]
public static InfoDataSet<TInfo> ExecuteQuery(
	string queryName,
	QueryDataParameters parameters,
	string where,
	string orderBy,
	int topN,
	string columns,
	int offset,
	int maxRecords,
	ref int totalRecords
)

Parameters

queryName
Type: SystemString
Name of the query in format application.class.queryname
parameters
Type: CMS.DataEngineQueryDataParameters
Query parameters
where
Type: SystemString
WHERE expression
orderBy
Type: SystemString
Sort expression
topN
Type: SystemInt32
Top N expression
columns
Type: SystemString
Columns expression
offset
Type: SystemInt32
Index of first record to get
maxRecords
Type: SystemInt32
Maximum number of records to get. If maxRecords is zero or less, all records are returned (no paging is used)
totalRecords
Type: SystemInt32
Returns total records

Return Value

Type: InfoDataSetTInfo
See Also