Udostępnij za pośrednictwem


SqlCommandExtensions Members

Include Protected Members
Include Inherited Members

Methods

  Name Description
Public methodStatic member ExecuteNonQueryWithRetry(SqlCommand)
Executes a Transact-SQL statement against the connection and returns the number of rows affected. Uses the default retry policy when executing the command.
Public methodStatic member ExecuteNonQueryWithRetry(SqlCommand, RetryPolicy)
Executes a Transact-SQL statement against the connection and returns the number of rows affected. Uses the specified retry policy when executing the command.
Public methodStatic member ExecuteNonQueryWithRetry(SqlCommand, RetryPolicy, RetryPolicy)
Executes a Transact-SQL statement against the connection and returns the number of rows affected. Uses the specified retry policies when executing the command and establishing a connection.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand)
Sends the specified command to the connection and builds a SqlDataReader object that contains the results. Uses the default retry policy when executing the command.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand, RetryPolicy)
Sends the specified command to the connection and builds a SqlDataReader object that contains the results. Uses the specified retry policy when executing the command.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand, CommandBehavior)
Sends the specified command to the connection and builds a SqlDataReader object by using the specified command behavior. Uses the default retry policy when executing the command.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand, RetryPolicy, RetryPolicy)
Sends the specified command to the connection and builds a SqlDataReader object that contains the results. Uses the specified retry policies when executing the command and establishing a connection.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand, CommandBehavior, RetryPolicy)
Sends the specified command to the connection and builds a SqlDataReader object by using the specified command behavior. Uses the specified retry policy when executing the command.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand, CommandBehavior, RetryPolicy, RetryPolicy)
Sends the specified command to the connection and builds a SqlDataReader object by using the specified command behavior. Uses the specified retry policies when executing the command and establishing a connection.
Public methodStatic member ExecuteScalarWithRetry(SqlCommand)
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Uses the default retry policy when executing the command.
Public methodStatic member ExecuteScalarWithRetry(SqlCommand, RetryPolicy)
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Uses the specified retry policy when executing the command.
Public methodStatic member ExecuteScalarWithRetry(SqlCommand, RetryPolicy, RetryPolicy)
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored. Uses the specified retry policies when executing the command and establishing a connection.
Public methodStatic member ExecuteXmlReaderWithRetry(SqlCommand)
Sends the specified command to the connection and builds an XmlReader object that contains the results. Uses the default retry policy when executing the command.
Public methodStatic member ExecuteXmlReaderWithRetry(SqlCommand, RetryPolicy)
Sends the specified command to the connection and builds an XmlReader object that contains the results. Uses the specified retry policy when executing the command.
Public methodStatic member ExecuteXmlReaderWithRetry(SqlCommand, RetryPolicy, RetryPolicy)
Sends the specified command to the connection and builds an XmlReader object that contains the results. Uses the specified retry policies when executing the command and establishing a connection.

See Also

SqlCommandExtensions Class

Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling Namespace