SqlDatabase Members

Initializes a new instance of the SqlDatabase class with a connection string.

Adds a new In DbParameter object to the given command.

Adds a new In DbParameter object to the given command.

Adds a new In DbParameter object to the given command.

Adds a new Out DbParameter object to the given command.

Adds a new instance of a DbParameter object to the command.

Adds a new In DbParameter object to the given command.

Discovers parameters on the command and assigns the values from parameterValues to the commands Parameters list.

Initiates the asynchronous execution of the commandText interpreted as specified by the commandType which will return the number of rows affected.

Initiates the asynchronous execution of the storedProcedureName using the given parameterValues which will return the number of rows affected.

Initiates the asynchronous execution of the storedProcedureName using the given parameterValues inside a transaction which will return the number of rows affected.

Initiates the asynchronous execution of the commandText interpreted as specified by the commandType which will return a IDataReader. When the async operation completes, the callback will be invoked on another thread to process the result.

Initiates the asynchronous execution of storedProcedureName using the given parameterValues which will return a IDataReader.

Initiates the asynchronous execution of storedProcedureName using the given parameterValues inside a transaction which will return a IDataReader.

Initiates the asynchronous execution of the commandText interpreted as specified by the commandType which will return a single value.

Initiates the asynchronous execution of storedProcedureName using the given parameterValues which will return a single value.

Initiates the asynchronous execution of storedProcedureName using the given parameterValues inside a transaction which will return a single value.

Initiates the asynchronous execution of the SqlCommand inside a transaction which will result in a XmlReader.

Configures a given DbParameter.

Creates a connection for this database.

Adds a new instance of a DbParameter object.

All data readers get wrapped in objects so that they properly manage connections. Some derived Database classes will need to create a different wrapper, so this method is provided so that they can do this.

Discovers the parameters for a DbCommand.

Finishes asynchronous execution of a Transact-SQL statement, returning the number of affected records.

Finishes asynchronous execution of a Transact-SQL statement, returning the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Determines whether the specified Object is equal to the current Object.

Executes the commandText interpreted as specified by the commandType and returns the results in a new DataSet.

Executes the storedProcedureName with parameterValues and returns the results in a new DataSet.

Executes the storedProcedureName with parameterValues as part of the transaction and returns the results in a new DataSet within a transaction.

Executes the commandText interpreted as specified by the commandType and returns the number of rows affected.

Executes the storedProcedureName using the given parameterValues and returns the number of rows affected.

Executes the storedProcedureName using the given parameterValues within a transaction and returns the number of rows affected.

Executes the commandText interpreted as specified by the commandType and returns an IDataReader through which the result can be read. It is the responsibility of the caller to close the connection and reader when finished.

Executes the storedProcedureName with the given parameterValues and returns an IDataReader through which the result can be read. It is the responsibility of the caller to close the connection and reader when finished.

Executes the storedProcedureName with the given parameterValues within the given transaction and returns an IDataReader through which the result can be read. It is the responsibility of the caller to close the connection and reader when finished.

Executes the commandText interpreted as specified by the commandType and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Executes the storedProcedureName with the given parameterValues and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Executes the storedProcedureName with the given parameterValues within a transaction and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored.

Executes the SqlCommand in a transaction and returns a new XmlReader.

Gets a DbDataAdapter with Standard update behavior.

Serves as a hash function for a particular type.

Gets a parameter value.

Creates a DbCommand for a stored procedure.

Wraps around a derived class's implementation of the GetStoredProcCommandWrapper method and adds functionality for using this method with UpdateDataSet. The GetStoredProcCommandWrapper method (above) that takes a params array expects the array to be filled with VALUES for the parameters. This method differs from the GetStoredProcCommandWrapper method in that it allows a user to pass in a string array. It will also dynamically discover the parameters for the stored procedure and set the parameter's SourceColumns to the strings that are passed in. It does this by mapping the parameters to the strings IN ORDER. Thus, order is very important.

Gets a "wrapped" connection for use outside a transaction.

Loads a DataSet from a DbCommand.

Executes the command within the given transaction and adds a new DataTable to the existing DataSet.

Loads a DataSet with the results returned from a stored procedure.

Loads a DataSet with the results returned from a stored procedure executed in a transaction.

Determines if the number of parameters in the command matches the array of parameter values.

Sets the RowUpdated event for the data adapter.

Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet.

Calls the respective INSERT, UPDATE, or DELETE statements for each inserted, updated, or deleted row in the DataSet.

Returns the starting index for parameters in a command.

Creates a SprocAccessor<TResult> for the given stored procedure. The conversion from IDataRecord to TResult will be done for each property based on matching property name to column name.

Creates a SprocAccessor<TResult> for the given stored procedure.

Creates a SprocAccessor<TResult> for the given stored procedure.

Creates a SqlStringAccessor<TResult> for the given Transact-SQL query. The conversion from IDataRecord to TResult will be done for each property based on matching property name to column name.

Creates a SqlStringAccessor<TResult> for the given Transact-SQL query.

Creates a SqlStringAccessor<TResult> for the given Transact-SQL query.

Executes a stored procedure and returns the result as an enumerable of TResult. The conversion from IDataRecord to TResult will be done for each property based on matching property name to column name.

Executes a stored procedure and returns the result as an enumerable of TResult.

Executes a stored procedure and returns the result as an enumerable of TResult.

Executes a Transact-SQL query and returns the result as an enumerable of TResult. The conversion from IDataRecord to TResult will be done for each property based on matching property name to column name.

Executes a Transact-SQL query and returns the result as an enumerable of TResult. The conversion from IDataRecord to TResult will be done for each property based on matching property name to column name.

Gets the string used to open a database.

Gets the connection string without credentials.

Gets the parameter token used to delimit parameters for the SQL Server database.

Does this Database object support parameter discovery?