SqlBatch.ExecuteDbDataReader(CommandBehavior) Method

Definition

Namespace:: Microsoft.Data.SqlClient

Assembly:: Microsoft.Data.SqlClient.dll

Package:: Microsoft.Data.SqlClient v7.1.0

Package:: Microsoft.Data.SqlClient v5.2.0

Package:: Microsoft.Data.SqlClient v6.0.2

Package:: Microsoft.Data.SqlClient v6.1.3

Package:: Microsoft.Data.SqlClient v7.0.3

Source:: SqlBatch.cs

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:
 virtual System::Data::Common::DbDataReader ^ ExecuteDbDataReader(System::Data::CommandBehavior behavior);

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

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

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

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

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

Protected Overridable Function ExecuteDbDataReader (behavior As CommandBehavior) As 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. Only SequentialAccess and CloseConnection are supported at the batch level.

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