SqlBatchCommand Class

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.

SqlBatchCommand allows for the execution of multiple SQL commands in a SqlBatch.

public ref class SqlBatchCommand

public ref class SqlBatchCommand : System::Data::Common::DbBatchCommand

public class SqlBatchCommand

public class SqlBatchCommand : System.Data.Common.DbBatchCommand

type SqlBatchCommand = class

type SqlBatchCommand = class
    inherit DbBatchCommand

Public Class SqlBatchCommand

Public Class SqlBatchCommand
Inherits DbBatchCommand

Inheritance: Object
SqlBatchCommand

Inheritance: DbBatchCommand
SqlBatchCommand

Constructors

SqlBatchCommand()	Initializes a new SqlBatchCommand.
SqlBatchCommand(String, CommandType, IEnumerable<SqlParameter>, SqlCommandColumnEncryptionSetting)	Initializes a new SqlBatchCommand.

Properties

CanCreateParameter	Returns whether the CreateParameter() method is implemented.
ColumnEncryptionSetting	Not currently implemented. The encryption setting. For more information, see Always Encrypted.
CommandBehavior	One of the CommandBehavior values, indicating options for statement execution and data retrieval.
CommandText	Gets or sets the text command to run against the data source.
CommandType	Gets or sets how the CommandText property is interpreted.
DbParameterCollection	Gets the collection of SqlParameter objects.
Parameters	Gets the SqlParameterCollection.
RecordsAffected	Gets the number of rows changed, inserted, or deleted by execution of this specific SqlBatchCommand.

Methods

CreateParameter()

Creates a new instance of a SqlParameter object.

Applies to