The AdoHelper<(Of <(<'TFactory>)>)> type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | AdoHelper<(Of <(<'TFactory>)>)> | Initializes a new instance of the AdoHelper<(Of <(<'TFactory>)>)> class |
Methods
| Name | Description | |
|---|---|---|
 | AddUpdateEventHandlers |
Provider specific code to set up the updating/ed event handlers used by UpdateDataset
|
| AssignParameterValues(array<IDataParameter>[]()[][], DataRow) |
This method assigns dataRow column values to an array of IDataParameters
|
| AssignParameterValues(array<IDataParameter>[]()[][], array<Object>[]()[][]) |
This method assigns an array of values to an array of IDataParameters
|
| AssignParameterValues(IDataParameterCollection, DataRow) |
This method assigns dataRow column values to an IDataParameterCollection
|
| AttachParameters |
This method is used to attach array of IDataParameters to an IDbCommand.
This method will assign a value of DbNull to any parameter with a direction of
InputOutput and a value of null.
This behavior will prevent default values from being used, but
this will be the less common case than an intended pure output parameter (derived as InputOutput)
where the user provided no input value.
|
| CacheParameterSet(IDbConnection, String, array<IDataParameter>[]()[][]) |
Add parameter array to the cache
|
| CacheParameterSet(String, String, array<IDataParameter>[]()[][]) |
Add parameter array to the cache
|
| CleanParameterSyntax |
This method cleans up the parameter syntax for the provider
|
| ClearCommand |
This method clears (if necessary) the connection, transaction, command type and parameters
from the provided command
|
| CreateCommand(IDbConnection, String, array<String>[]()[][]) |
Simplify the creation of an IDbCommand object by allowing
a stored procedure and optional parameters to be provided
|
| CreateCommand(String, String, array<String>[]()[][]) |
Simplify the creation of an IDbCommand object by allowing
a stored procedure and optional parameters to be provided
|
| CreateCommand(IDbConnection, String, CommandType, array<IDataParameter>[]()[][]) |
Simplify the creation of an IDbCommand object by allowing
a stored procedure and optional parameters to be provided
|
| CreateCommand(String, String, CommandType, array<IDataParameter>[]()[][]) |
Simplify the creation of an IDbCommand object by allowing
a stored procedure and optional parameters to be provided
|
| DeriveParameters |
Calls the CommandBuilder.DeriveParameters method for the specified provider, doing any setup and cleanup necessary
|
| Equals | (Inherited from Object.) |
| ExecuteDataset(IDbCommand) |
Execute an IDbCommand (that returns a resultset) against the database specified in
the connection String.
|
| ExecuteDataset(IDbConnection, CommandType, String) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbConnection.
|
| ExecuteDataset(IDbConnection, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbConnection
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(IDbTransaction, CommandType, String) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbTransaction.
|
| ExecuteDataset(IDbTransaction, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified
IDbTransaction 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(String, CommandType, String) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the database specified in
the connection String.
|
| ExecuteDataset(String, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (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(IDbConnection, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the specified IDbConnection
using the provided parameters.
|
| ExecuteDataset(IDbTransaction, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the specified IDbTransaction
using the provided parameters.
|
| ExecuteDataset(String, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the database specified in the connection string
using the provided parameters.
|
| ExecuteDatasetTypedParams(IDbCommand, DataRow) |
Execute a stored procedure via an IDbCommand (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 assign the paraemter values based on row values.
|
| ExecuteDatasetTypedParams(IDbConnection, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbConnection
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(IDbTransaction, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbTransaction
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(String, String, DataRow) |
Execute a stored procedure via an IDbCommand (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.
|
| ExecuteNonQuery(IDbCommand) |
Execute an IDbCommand (that returns no resultset) against the database
|
| ExecuteNonQuery(IDbConnection, CommandType, String) |
Execute an IDbCommand (that returns no resultset and takes no parameters) against the provided IDbConnection.
|
| ExecuteNonQuery(IDbConnection, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns no resultset) against the specified IDbConnection
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(IDbTransaction, CommandType, String) |
Execute an IDbCommand (that returns no resultset and takes no parameters) against the provided IDbTransaction.
|
| ExecuteNonQuery(IDbTransaction, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns no resultset) against the specified
IDbTransaction 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(String, CommandType, String) |
Execute an IDbCommand (that returns no resultset and takes no parameters) against the database specified in
the connection string
|
| ExecuteNonQuery(String, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (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(IDbConnection, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns no resultset) against the specified IDbConnection
using the provided parameters.
|
| ExecuteNonQuery(IDbTransaction, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns no resultset) against the specified IDbTransaction
using the provided parameters.
|
| ExecuteNonQuery(String, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns no resultset) against the database specified in the connection string
using the provided parameters
|
| ExecuteNonQueryTypedParams(IDbCommand, DataRow) |
Execute a stored procedure via an IDbCommand (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 assign the parameter values based on row values.
|
| ExecuteNonQueryTypedParams(IDbConnection, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns no resultset) against the specified IDbConnection
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(IDbTransaction, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns no resultset) against the specified
IDbTransaction 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(String, String, DataRow) |
Execute a stored procedure via an IDbCommand (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.
|
| ExecuteReader(IDbCommand) |
Execute an IDbCommand (that returns a resultset) against the database specified in
the connection String.
|
| ExecuteReader(IDbCommand, AdoHelper<(Of <<'(TFactory>)>>)..::..AdoConnectionOwnership) |
Execute an IDbCommand (that returns a resultset) against the database specified in
the connection String.
|
| ExecuteReader(IDbConnection, CommandType, String) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbConnection.
|
| ExecuteReader(IDbConnection, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbConnection
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(IDbTransaction, CommandType, String) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbTransaction.
|
| ExecuteReader(IDbTransaction, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified
IDbTransaction 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(String, CommandType, String) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the database specified in
the connection String.
|
| ExecuteReader(String, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (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(IDbConnection, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the specified IDbConnection
using the provided parameters.
|
| ExecuteReader(IDbTransaction, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the specified IDbTransaction
using the provided parameters.
|
| ExecuteReader(String, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the database specified in the connection string
using the provided parameters.
|
| ExecuteReaderTypedParams(IDbCommand, DataRow) |
Execute a stored procedure via an IDbCommand (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 assign the parameter values based on parameter order.
|
| ExecuteReaderTypedParams(IDbConnection, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbConnection
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(IDbTransaction, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbTransaction
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(String, String, DataRow) |
Execute a stored procedure via an IDbCommand (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.
|
| ExecuteScalar(IDbCommand) |
Execute an IDbCommand (that returns a 1x1 resultset) against the database specified in
the connection String.
|
| ExecuteScalar(IDbConnection, CommandType, String) |
Execute an IDbCommand (that returns a 1x1 resultset and takes no parameters) against the provided IDbConnection.
|
| ExecuteScalar(IDbConnection, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a 1x1 resultset) against the specified IDbConnection
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(IDbTransaction, CommandType, String) |
Execute an IDbCommand (that returns a 1x1 resultset and takes no parameters) against the provided IDbTransaction.
|
| ExecuteScalar(IDbTransaction, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a 1x1 resultset) against the specified
IDbTransaction 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(String, CommandType, String) |
Execute an IDbCommand (that returns a 1x1 resultset and takes no parameters) against the database specified in
the connection String.
|
| ExecuteScalar(String, String, array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (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(IDbConnection, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a 1x1 resultset) against the specified IDbConnection
using the provided parameters.
|
| ExecuteScalar(IDbTransaction, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a 1x1 resultset) against the specified IDbTransaction
using the provided parameters.
|
| ExecuteScalar(String, CommandType, String, array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a 1x1 resultset) against the database specified in the connection string
using the provided parameters.
|
| ExecuteScalarTypedParams(IDbCommand, DataRow) |
Execute a stored procedure via an IDbCommand (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 assign the parameter values based on parameter order.
|
| ExecuteScalarTypedParams(IDbConnection, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns a 1x1 resultset) against the specified IDbConnection
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(IDbTransaction, String, DataRow) |
Execute a stored procedure via an IDbCommand (that returns a 1x1 resultset) against the specified IDbTransaction
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(String, String, DataRow) |
Execute a stored procedure via an IDbCommand (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.
|
| FillDataset(IDbCommand, DataSet, array<String>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the database specified in
the connection String.
|
| FillDataset(IDbConnection, CommandType, String, DataSet, array<String>[]()[][]) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbConnection.
|
| FillDataset(IDbConnection, String, DataSet, array<String>[]()[][], array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified IDbConnection
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(IDbTransaction, CommandType, String, DataSet, array<String>[]()[][]) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the provided IDbTransaction.
|
| FillDataset(IDbTransaction, String, DataSet, array<String>[]()[][], array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (that returns a resultset) against the specified
IDbTransaction 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(String, CommandType, String, DataSet, array<String>[]()[][]) |
Execute an IDbCommand (that returns a resultset and takes no parameters) against the database specified in
the connection String.
|
| FillDataset(String, String, DataSet, array<String>[]()[][], array<Object>[]()[][]) |
Execute a stored procedure via an IDbCommand (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(IDbConnection, CommandType, String, DataSet, array<String>[]()[][], array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the specified IDbConnection
using the provided parameters.
|
| FillDataset(IDbTransaction, CommandType, String, DataSet, array<String>[]()[][], array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the specified IDbTransaction
using the provided parameters.
|
| FillDataset(String, CommandType, String, DataSet, array<String>[]()[][], array<IDataParameter>[]()[][]) |
Execute an IDbCommand (that returns a resultset) against the database specified in the connection string
using the provided parameters.
|
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GetBlobParameter |
Handle any provider-specific issues with BLOBs here by "washing" the IDataParameter and returning a new one that is set up appropriately for the provider.
|
| GetCachedParameterSet(IDbConnection, String) |
Retrieve a parameter array from the cache
|
| GetCachedParameterSet(String, String) |
Retrieve a parameter array from the cache
|
| GetConnection |
Returns an IDbConnection object for the given connection string
|
| GetDataAdapter |
Returns an IDbDataAdapter object
|
| GetDataParameters |
Returns an array of IDataParameters of the specified size
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetParameter()()()() |
Returns an IDataParameter object
|
| GetParameter(String, Object) |
Get an IDataParameter for use in a SQL command
|
| GetParameter(String, DbType, Int32, ParameterDirection) |
Get an IDataParameter for use in a SQL command
|
| GetParameter(String, DbType, Int32, String, DataRowVersion) |
Get an IDataParameter for use in a SQL command
|
| GetSpParameterSet(IDbConnection, String) |
Retrieves the set of IDataParameters appropriate for the stored procedure
|
| GetSpParameterSet(String, String) |
Retrieves the set of IDataParameters appropriate for the stored procedure
|
| GetSpParameterSet(IDbConnection, String, Boolean) |
Retrieves the set of IDataParameters appropriate for the stored procedure
|
| GetSpParameterSet(String, String, Boolean) |
Retrieves the set of IDataParameters appropriate for the stored procedure
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| PrepareCommand |
This method opens (if necessary) and assigns a connection, transaction, command type and parameters
to the provided command
|
| RowUpdated |
This method consumes the RowUpdatedEvent and passes it on to the consumer specifed in the call to UpdateDataset
|
| RowUpdating |
This method consumes the RowUpdatingEvent and passes it on to the consumer specifed in the call to UpdateDataset
|
| SetCommand |
Set up a command for updating a DataSet.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| UpdateDataset(IDbCommand, IDbCommand, IDbCommand, DataSet, String) |
Executes the respective command for each inserted, updated, or deleted row in the DataSet.
|
| UpdateDataset(IDbCommand, IDbCommand, IDbCommand, DataSet, String, AdoHelper<(Of <<'(TFactory>)>>)..::..RowUpdatingHandler, AdoHelper<(Of <<'(TFactory>)>>)..::..RowUpdatedHandler) |
Executes the IDbCommand for each inserted, updated, or deleted row in the DataSet also implementing RowUpdating and RowUpdated Event Handlers
|
Fields
| Name | Description | |
|---|---|---|
 | m_rowUpdated |
Internal handler used for bubbling up the event to the user
|
| m_rowUpdating |
Internal handler used for bubbling up the event to the user
|
See Also
