System.Data.SqlClient.SqlCommand

SqlCommand

public sealed class SqlCommand : DbCommand, ICloneable

Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited.

public SqlConnection Connection { get; set; }

Gets or sets the SqlConnection used by this instance of the SqlCommand.

public SqlNotificationRequest Notification { get; set; }

public SqlParameterCollection Parameters { get; }

Gets the SqlParameterCollection.

public SqlTransaction Transaction { get; set; }

Gets or sets the SqlTransaction within which the SqlCommand executes.

public event StatementCompletedEventHandler StatementCompleted

Occurs when the execution of a Transact-SQL statement completes.

public SqlCommand()

Initializes a new instance of the SqlCommand class.

public SqlCommand(string cmdText)

Initializes a new instance of the SqlCommand class with the text of the query.

public SqlCommand(string cmdText, SqlConnection connection)

Initializes a new instance of the SqlCommand class with the text of the query and a SqlConnection.

public SqlCommand(string cmdText, SqlConnection connection, SqlTransaction transaction)

Initializes a new instance of the SqlCommand class with the text of the query, a SqlConnection, and the SqlTransaction.

public IAsyncResult BeginExecuteNonQuery()

public IAsyncResult BeginExecuteNonQuery(AsyncCallback callback, object stateObject)

public IAsyncResult BeginExecuteReader()

public IAsyncResult BeginExecuteReader(AsyncCallback callback, object stateObject)

public IAsyncResult BeginExecuteReader(AsyncCallback callback, object stateObject, CommandBehavior behavior)

public IAsyncResult BeginExecuteReader(CommandBehavior behavior)

public IAsyncResult BeginExecuteXmlReader()

public IAsyncResult BeginExecuteXmlReader(AsyncCallback callback, object stateObject)

public SqlCommand Clone()

Creates a new SqlCommand object that is a copy of the current instance.

public SqlParameter CreateParameter()

Creates a new instance of a SqlParameter object.

public int EndExecuteNonQuery(IAsyncResult asyncResult)

public SqlDataReader EndExecuteReader(IAsyncResult asyncResult)

public XmlReader EndExecuteXmlReader(IAsyncResult asyncResult)

public SqlDataReader ExecuteReader()

Sends the CommandText to the Connection and builds a SqlDataReader.

public SqlDataReader ExecuteReader(CommandBehavior behavior)

Sends the CommandText to the Connection, and builds a SqlDataReader using one of the CommandBehavior values.

public Task<SqlDataReader> ExecuteReaderAsync()

An asynchronous version of ExecuteReader, which sends the CommandText to the Connection and builds a SqlDataReader. Exceptions will be reported via the returned Task object.

public Task<SqlDataReader> ExecuteReaderAsync(CommandBehavior behavior)

An asynchronous version of ExecuteReader, which sends the CommandText to the Connection, and builds a SqlDataReader. Exceptions will be reported via the returned Task object.

public Task<SqlDataReader> ExecuteReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)

An asynchronous version of ExecuteReader, which sends the CommandText to the Connection, and builds a SqlDataReader The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

public Task<SqlDataReader> ExecuteReaderAsync(CancellationToken cancellationToken)

An asynchronous version of ExecuteReader, which sends the CommandText to the Connection and builds a SqlDataReader. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

public XmlReader ExecuteXmlReader()

Sends the CommandText to the Connection and builds an XmlReader object.

public Task<XmlReader> ExecuteXmlReaderAsync()

An asynchronous version of ExecuteXmlReader, which sends the CommandText to the Connection and builds an XmlReader object. Exceptions will be reported via the returned Task object.

public Task<XmlReader> ExecuteXmlReaderAsync(CancellationToken cancellationToken)

An asynchronous version of ExecuteXmlReader, which sends the CommandText to the Connection and builds an XmlReader object. The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.

public void ResetCommandTimeout()