Microsoft.Data.SqlClient.SqlBatchCommand

public class SqlBatchCommand

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

Returns whether the CreateParameter method is implemented.

public SqlCommandColumnEncryptionSetting ColumnEncryptionSetting { get; set; }

Not currently implemented. The encryption setting. For more information, see Always Encrypted.

public CommandBehavior CommandBehavior { get; set; }

An instance of CommandBehavior, specifying options for statement execution and data retrieval. Only SchemaOnly and KeyInfo are supported at the statement level.

public string CommandText { get; set; }

Gets or sets the text command to run against the data source.

public CommandType CommandType { get; set; }

Gets or sets how the CommandText property is interpreted.

protected virtual DbParameterCollection DbParameterCollection { get; }

Gets the collection of SqlParameter objects.

public SqlParameterCollection Parameters { get; }

Gets the SqlParameterCollection.

public int RecordsAffected { get; }

Gets the number of rows changed, inserted, or deleted by execution of this specific SqlBatchCommand.

public SqlBatchCommand()

Initializes a new SqlBatchCommand.

public SqlBatchCommand(string commandText, CommandType commandType = 1, IEnumerable<SqlParameter> parameters = null, SqlCommandColumnEncryptionSetting columnEncryptionSetting = 0)

Initializes a new SqlBatchCommand.

public DbParameter CreateParameter()

Creates a new instance of a SqlParameter object.