West Wind Web Toolkit for ASP.NET
Class DataAccessBase
Class DataAccessBase
public abstract class DataAccessBase : object, IDisposable
| Member | Description | |
|---|---|---|
 |
dbProvider | The internally used dbProvider |
 |
BeginTransaction | Starts a new transaction on this connection/instance public virtual bool BeginTransaction();
|
|
CloseConnection | Closes a connection public abstract void CloseConnection(DbCommand Command);
public abstract void CloseConnection();
|
|
CommitTransaction | Commits all changes to the database and ends the transaction public virtual bool CommitTransaction();
|
|
CreateCommand | Creates a Command object and opens a connection public abstract DbCommand CreateCommand(string sql,
CommandType commandType, DbParameter[] parameters); public virtual DbCommand CreateCommand(string sql,
DbParameter[] parameters); |
|
CreatePagingCommand | Sql 2005 specific semi-generic paging routine public virtual DbCommand CreatePagingCommand(string sql,
int pageSize, int page, string sortOrderFields, DbParameter[] Parameters); |
|
CreateParameter | Used to create named parameters to pass to commands or the various methods of this class. public abstract DbParameter CreateParameter(string parameterName,
object value); public virtual DbParameter CreateParameter(string parameterName,
object value, ParameterDirection parameterDirection); public virtual DbParameter CreateParameter(string parameterName,
object value, int size); public virtual DbParameter CreateParameter(string parameterName,
object value, DbType type); public virtual DbParameter CreateParameter(string parameterName,
object value, DbType type, int size); |
|
Dispose | public sealed void Dispose();
|
|
ExecuteDataSet | Returns a DataSet/DataTable from a Sql Command string passed in. public abstract DataSet ExecuteDataSet(string tablename,
DbCommand command, DbParameter[] parameters); public virtual DataSet ExecuteDataSet(string tablename,
string sql, DbParameter[] parameters); public abstract DataSet ExecuteDataSet(DataSet dataSet,
string Tablename, DbCommand Command, DbParameter[] Parameters); public virtual DataSet ExecuteDataSet(DataSet dataSet,
string tablename, string sql, DbParameter[] parameters); |
|
ExecuteDynamicDataReader | Executes a Sql statement and returns a dynamic DataReader instance that exposes each field as a property public virtual object ExecuteDynamicDataReader(string sql,
DbParameter[] parameters); |
|
ExecuteNonQuery | Executes a non-query command and returns the affected records public abstract int ExecuteNonQuery(DbCommand Command,
DbParameter[] Parameters); public virtual int ExecuteNonQuery(string sql,
DbParameter[] parameters); |
|
ExecuteReader | Executes a SQL Command object and returns a SqlDataReader object public abstract DbDataReader ExecuteReader(DbCommand Command,
DbParameter[] Parameters); public virtual DbDataReader ExecuteReader(string sql,
DbParameter[] parameters); |
|
ExecuteReader<T> | Executes a SQL statement and creates an object list using Reflection. public virtual List<T> ExecuteReader<T>(string sql,
DbParameter[] parameters); public virtual List<T> ExecuteReader<T>(string sql,
string propertiesToExclude, DbParameter[] parameters); public virtual List<T> ExecuteReader<T>(DbCommand sqlCommand,
DbParameter[] parameters); |
|
ExecuteScalar | Executes a command and returns a scalar value from it public abstract object ExecuteScalar(DbCommand Command,
DbParameter[] Parameters); public virtual object ExecuteScalar(string sql,
DbParameter[] parameters); |
|
ExecuteTable | Returns a DataTable from a Sql Command string passed in. public abstract DataTable ExecuteTable(string Tablename,
DbCommand Command, DbParameter[] Parameters); public virtual DataTable ExecuteTable(string Tablename,
string Sql, DbParameter[] Parameters); |
|
GetEntity | Generic routine to retrieve an object from a database record The object properties must match the database fields. public virtual bool GetEntity(object entity,
DbCommand command, string fieldsToSkip); public virtual bool GetEntity(object Entity,
string Table, string KeyField, object KeyValue, string FieldsToSkip); |
|
InsertEntity | public object InsertEntity(object entity,
string table, string fieldsToSkip); |
|
OpenConnection | Opens a Sql Connection based on the connection string. Called internally but externally accessible. Sets the internal _Connection property. public abstract bool OpenConnection();
|
|
RollbackTransaction | Rolls back a transaction public virtual bool RollbackTransaction();
|
|
RunSqlScript | Executes a long SQL script that contains batches (GO commands). This code breaks the script into individual commands and captures all execution errors. public bool RunSqlScript(string Script,
bool ContinueOnError, bool ScriptIsFile); |
|
SaveEntity | Saves an enity into the database using insert or update as required. Requires a keyfield that exists on both the entity and the database. public virtual bool SaveEntity(object entity,
string table, string keyField, string fieldsToSkip); |
|
UpdateEntity | Updates an entity object that has matching fields in the database for each public property. Kind of a poor man's quick entity update mechanism. public virtual bool UpdateEntity(object entity,
string table, string keyField, string fieldsToSkip); public virtual bool UpdateEntity(object Entity,
string Table, string KeyField, string FieldsToSkip, string FieldsToUpdate); |
 |
Connection | The SQL Connection object used for connections |
|
ConnectionString | ConnectionString for the data access component |
|
ErrorMessage | An error message if a method fails |
|
ErrorNumber | Optional error number returned by failed SQL commands |
|
ExecuteWithSchema | Determines whether extended schema information is returned for queries from the server. Useful if schema needs to be returned as part of DataSet XML creation |
|
Transaction | A SQL Transaction object that may be active. You can also set this object explcitly |
