AbstractDataConnection.ExecuteReader Method

Executes the query and returns result of the query as a DbDataReader.

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0

Syntax

public virtual DbDataReader ExecuteReader(
	string queryText,
	QueryDataParameters queryParams,
	QueryTypeEnum queryType,
	CommandBehavior commandBehavior
)

Parameters

queryText

Type: System.String
Query or stored procedure to be run.

queryParams

Type: CMS.DataEngine.QueryDataParameters
Query parameters.

queryType

Type: CMS.DataEngine.QueryTypeEnum
Indicates if query is a SQL query or stored procedure.

commandBehavior

Type: System.Data.CommandBehavior
Command behavior.

Return Value

Type: DbDataReader

Remarks

The method executes the query with command behavior CloseConnection if passed commandBehavior is set to Default and connection is not opened.