SqlHelper Members
The SqlHelper type exposes the following members.
Methods
Name | Description | |
---|---|---|
![]() ![]() |
CreateCommand |
Simplify the creation of a Sql command object by allowing
a stored procedure and optional parameters to be provided
|
![]() ![]() |
ExecuteDataset(String, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in
the connection string.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteDataset(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteDataset(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteDataset(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteDataset(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteDatasetAsync(String, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in
the connection string.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteDatasetAsync(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteDatasetAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteDatasetAsync(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteDatasetAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteNonQuery(String, CommandType, String) |
Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in
the connection string
|
![]() ![]() |
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
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteNonQuery(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteNonQuery(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns no resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteNonQuery(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteNonQuery(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns no resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteNonQueryAsync(String, CommandType, String) |
Execute a SqlCommand (that returns no resultset and takes no parameters) against the database specified in
the connection string
|
![]() ![]() |
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
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteNonQueryAsync(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteNonQueryAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns no resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteNonQueryAsync(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns no resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteNonQueryAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns no resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteReader(String, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in
the connection string.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteReader(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteReader(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteReader(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteReader(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteReaderAsync(String, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the database specified in
the connection string.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteReaderAsync(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteReaderAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteReaderAsync(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteReaderAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteScalar(String, CommandType, String) |
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in
the connection string.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteScalar(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteScalar(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteScalar(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteScalar(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteScalarAsync(String, CommandType, String) |
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in
the connection string.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteScalarAsync(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteScalarAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteScalarAsync(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a 1x1 resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteScalarAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a 1x1 resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteXmlReader(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteXmlReader(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteXmlReader(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteXmlReader(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteXmlReaderAsync(SqlConnection, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
ExecuteXmlReaderAsync(SqlConnection, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
ExecuteXmlReaderAsync(SqlTransaction, CommandType, String) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
ExecuteXmlReaderAsync(SqlTransaction, CommandType, String, array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
FillDataset(SqlConnection, CommandType, String, DataSet, array<String>[]()[][]) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
FillDataset(SqlConnection, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
FillDataset(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][]) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
FillDataset(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
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.
|
![]() ![]() |
FillDatasetAsync(SqlConnection, CommandType, String, DataSet, array<String>[]()[][]) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlConnection.
|
![]() ![]() |
FillDatasetAsync(SqlConnection, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlConnection
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
FillDatasetAsync(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][]) |
Execute a SqlCommand (that returns a resultset and takes no parameters) against the provided SqlTransaction.
|
![]() ![]() |
FillDatasetAsync(SqlTransaction, CommandType, String, DataSet, array<String>[]()[][], array<SqlParameter>[]()[][]) |
Execute a SqlCommand (that returns a resultset) against the specified SqlTransaction
using the provided parameters.
|
![]() ![]() |
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.
|
![]() ![]() |
UpdateDataset |
Executes the respective command for each inserted, updated, or deleted row in the DataSet.
|