SqlHelper Members

The SqlHelper type exposes the following members.

Methods

  Name Description
Public method Static member CreateCommand
Simplify the creation of a Sql command object by allowing a stored procedure and optional parameters to be provided
Public method Static member ExecuteDataset(String, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Public method Static member ExecuteDataset(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
Public method Static member ExecuteDataset(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteDataset(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteDataset(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteDataset(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteDataset(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteDataset(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteDataset(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteDatasetAsync(String, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Public method Static member ExecuteDatasetAsync(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
Public method Static member ExecuteDatasetAsync(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteDatasetAsync(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteDatasetAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteDatasetAsync(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteDatasetAsync(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteDatasetAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteDatasetAsync(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteDatasetTypedParams(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteDatasetTypedParams(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the dataRow column values as the store procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteDatasetTypedParams(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteDatasetTypedParamsAsync(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteDatasetTypedParamsAsync(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the dataRow column values as the store procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteDatasetTypedParamsAsync(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteNonQuery(String, CommandType, String)
Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in the connection string
Public method Static member ExecuteNonQuery(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameters
Public method Static member ExecuteNonQuery(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteNonQuery(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteNonQuery(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns no resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteNonQuery(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteNonQuery(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteNonQuery(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns no resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteNonQuery(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteNonQueryAsync(String, CommandType, String)
Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in the connection string
Public method Static member ExecuteNonQueryAsync(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameters
Public method Static member ExecuteNonQueryAsync(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns no resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteNonQueryAsync(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteNonQueryAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns no resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteNonQueryAsync(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteNonQueryAsync(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteNonQueryAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns no resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteNonQueryAsync(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteNonQueryTypedParams(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns no resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteNonQueryTypedParams(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteNonQueryTypedParams(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteNonQueryTypedParamsAsync(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns no resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteNonQueryTypedParamsAsync(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteNonQueryTypedParamsAsync(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on row values.
Public method Static member ExecuteReader(String, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Public method Static member ExecuteReader(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
Public method Static member ExecuteReader(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReader(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteReader(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteReader(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReader(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteReader(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteReader(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderAsync(String, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Public method Static member ExecuteReaderAsync(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
Public method Static member ExecuteReaderAsync(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderAsync(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteReaderAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteReaderAsync(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderAsync(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteReaderAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteReaderAsync(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderTypedParams(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderTypedParams(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderTypedParams(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderTypedParamsAsync(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderTypedParamsAsync(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteReaderTypedParamsAsync(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalar(String, CommandType, String)
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in the connection string.
Public method Static member ExecuteScalar(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a 1x1 resultset) against the database specified in the connection string using the provided parameters.
Public method Static member ExecuteScalar(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalar(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteScalar(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteScalar(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalar(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteScalar(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteScalar(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarAsync(String, CommandType, String)
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in the connection string.
Public method Static member ExecuteScalarAsync(String, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a 1x1 resultset) against the database specified in the connection string using the provided parameters.
Public method Static member ExecuteScalarAsync(String, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarAsync(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteScalarAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteScalarAsync(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarAsync(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteScalarAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteScalarAsync(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarTypedParams(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarTypedParams(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarTypedParams(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarTypedParamsAsync(String, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the database specified in the connection string using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarTypedParamsAsync(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteScalarTypedParamsAsync(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReader(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteXmlReader(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteXmlReader(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReader(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteXmlReader(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteXmlReader(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReaderAsync(SqlConnection, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member ExecuteXmlReaderAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member ExecuteXmlReaderAsync(SqlConnection, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReaderAsync(SqlTransaction, CommandType, String)
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member ExecuteXmlReaderAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member ExecuteXmlReaderAsync(SqlTransaction, String, array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReaderTypedParams(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReaderTypedParams(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReaderTypedParamsAsync(SqlConnection, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member ExecuteXmlReaderTypedParamsAsync(SqlTransaction, String, DataRow)
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the dataRow column values as the stored procedure's parameters values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member FillDataset(String, CommandType, String, DataSet, array<String>[]()[][])
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Public method Static member FillDataset(String, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
Public method Static member FillDataset(String, String, DataSet, array<String>[]()[][], array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member FillDataset(SqlConnection, CommandType, String, DataSet, array<String>[]()[][])
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member FillDataset(SqlConnection, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member FillDataset(SqlConnection, String, DataSet, array<String>[]()[][], array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member FillDataset(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][])
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member FillDataset(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member FillDataset(SqlTransaction, String, DataSet, array<String>[]()[][], array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member FillDatasetAsync(String, CommandType, String, DataSet, array<String>[]()[][])
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in the connection string.
Public method Static member FillDatasetAsync(String, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameters.
Public method Static member FillDatasetAsync(String, String, DataSet, array<String>[]()[][], array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the database specified in the connection string using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member FillDatasetAsync(SqlConnection, CommandType, String, DataSet, array<String>[]()[][])
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
Public method Static member FillDatasetAsync(SqlConnection, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameters.
Public method Static member FillDatasetAsync(SqlConnection, String, DataSet, array<String>[]()[][], array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlConnection using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member FillDatasetAsync(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][])
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
Public method Static member FillDatasetAsync(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][])
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameters.
Public method Static member FillDatasetAsync(SqlTransaction, String, DataSet, array<String>[]()[][], array<Object>[]()[][])
Execute a stored procedure via a SqlCommand (that returns a resultset) against the specified SqlTransaction using the provided parameter values. This method will query the database to discover the parameters for the stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
Public method Static member UpdateDataset
Executes the respective command for each inserted, updated, or deleted row in the DataSet.

See Also

SqlHelper Class
Core Namespace