The DataAccessHelper type exposes the following members.
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.) |