SqlBatch.ExecuteDbDataReader(CommandBehavior) Method

Reference

Definition

Namespace:: Microsoft.Data.SqlClient

Assembly:: Microsoft.Data.SqlClient.dll

Package:: Microsoft.Data.SqlClient v5.2.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Executes the batch against its connection, returning a SqlDataReader which can be used to access the results.

protected:
 override System::Data::Common::DbDataReader ^ ExecuteDbDataReader(System::Data::CommandBehavior behavior);

protected override System.Data.Common.DbDataReader ExecuteDbDataReader (System.Data.CommandBehavior behavior);

override this.ExecuteDbDataReader : System.Data.CommandBehavior -> System.Data.Common.DbDataReader

Protected Overrides Function ExecuteDbDataReader (behavior As CommandBehavior) As DbDataReader

Parameters

behavior: CommandBehavior

An instance of CommandBehavior, specifying options for batch execution and data retrieval.

Returns

DbDataReader

A DbDataReader object.

Exceptions

SqlException

An error occurred while executing the batch.

ArgumentException

The CommandBehavior value is invalid.

Remarks

When the batch returns multiple result sets from different commands, NextResult() can be used to advance the reader to the next result set.

Note

This method benefits from ExecuteReader(CommandBehavior), and all the expected exceptions of that method also apply here.

Applies to