The DataAccessHelper type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | DataAccessHelper | Initializes a new instance of the DataAccessHelper class |
Methods
| Name | Description | |
|---|---|---|
 | AddBitInputParam |
Add bit parameter to stored procedure
|
| AddDateTimeInputParam |
Add data time parameter to stored procedure
|
| AddInputParam |
Add an input paramater, passing DBNull for null paramater values
|
| AddIntInputParam |
Add 32-bit int parameter to stored procedure
|
| AddIntOutputParam |
Add 32-bit int OUTPUT parameter up to stored procedure
|
| AddLongStringInputParam |
Add string parameter up to 2000 characters to stored procedure
|
| AddStringInputParam |
Add string parameter up to 250 characters to stored procedure
|
| AddStringOutputParam |
Add string OUTPUT parameter up to 250 charactes to stored procedure
|
| AddTextInputParam |
Add text parameter to stored procedure
|
| BeginTransaction | |
| CreateCommand(String) |
for stored procs only
|
| CreateCommand(String, CommandType) | |
| CreateCommand(String, SqlTransaction) | |
| CreateSqlCommand(String) | |
| CreateSqlCommand(String, SqlConnection) | |
| CreateWarehouseCommand | |
| CreateWarehouseSqlCommand | |
| DeriveParams(SqlCommand, DataRow) | |
| DeriveParams(SqlCommand, DataTable) | |
| EndTransaction | |
| Equals |
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.) |
| ExecuteScalar | |
| ExecuteSql | |
| ExecuteSqlSelect |
Can be used to execute SQL statements, although stored procedures should be used whenever possible
|
| ExecuteSqlSelectOnWarehouse |
Executes a SQL SELECT statement on the Data Warehouse and returns a view of the results
|
| ExecuteStoredProcOnWarehouse |
Executes a SQL Stored Proc on the Data Warehouse and returns a view of the results
|
 | Finalize |
Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
(Inherited from Object.) |
| GetConnection | |
| GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) |
| GetList(SqlCommand) |
Fill DataSet based on select statement
|
| GetList(SqlCommand, DataTable) | |
| GetList(SqlCommand, Int32, Int32) |
Fill DataSet based on select statement and record interval
|
| GetRecord(SqlCommand) | |
| GetRecord(SqlCommand, DataTable) | |
| GetRecord(SqlCommand, DataSet, String) | |
| GetType |
Gets the Type of the current instance.
(Inherited from Object.) |
| GetWarehouseConnection |
Returns the connection string for the Data Warehouse
|
| MemberwiseClone |
Creates a shallow copy of the current Object.
(Inherited from Object.) |
| SetParams | |
| ToDBDate |
NOTE: This will throw an error on invalid date
|
| ToString |
Returns a String that represents the current Object.
(Inherited from Object.) |
