Partager via


SqlCommandExtensions Members

Include Protected Members
Include Inherited Members

Retired Content

This content and the technology described is outdated and is no longer being maintained. For more information about Transient Fault Handling, see Transient Fault Handling.

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 policy when executing the command. Uses a separate specified retry policy when establishing a connection.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand)
Sends the specified command to the connection and builds a SqlDataReader object containing 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 containing 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 using one of the CommandBehavior values. 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 containing the results. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.
Public methodStatic member ExecuteReaderWithRetry(SqlCommand, CommandBehavior, RetryPolicy)
Sends the specified command to the connection and builds a SqlDataReader object using one of the CommandBehavior values. 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 using one of the CommandBehavior values. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when 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 policy when executing the command. Uses a separate specified retry policy when establishing a connection.
Public methodStatic member ExecuteXmlReaderWithRetry(SqlCommand)
Sends the specified command to the connection and builds an XmlReader object containing 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 containing 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 containing the results. Uses the specified retry policy when executing the command. Uses a separate specified retry policy when establishing a connection.

See Also

SqlCommandExtensions Class

Microsoft.Practices.EnterpriseLibrary.WindowsAzure.TransientFaultHandling.SqlAzure Namespace