West Wind Toolkit for .NET
Class SqlDataAccess
Class SqlDataAccess
public class SqlDataAccess : DataAccessBase
| Member | Description | |
|---|---|---|
 |
Constructor | |
 |
dbProvider | Inherited from Westwind.Utilities.Data.DataAccessBase |
 |
BeginTransaction | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual bool BeginTransaction();
|
|
CloseConnection | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual void CloseConnection(DbCommand Command);
public virtual void CloseConnection();
|
|
CommitTransaction | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual bool CommitTransaction();
|
|
CreateCommand | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual DbCommand CreateCommand(string sql,
CommandType commandType, Object[] parameters); public virtual DbCommand CreateCommand(string sql,
Object[] parameters); |
|
CreatePagingCommand | Sql 2005 and later specific semi-generic paging routine public virtual DbCommand CreatePagingCommand(string sql,
int pageSize, int page, string sortOrderFields, Object[] Parameters); |
|
CreateParameter | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual 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 | Inherited from Westwind.Utilities.Data.DataAccessBase public sealed void Dispose();
|
|
Equals | Inherited from System.Object public virtual bool Equals(object obj);
|
|
ExecuteDataSet | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual DataSet ExecuteDataSet(string Tablename,
DbCommand Command, Object[] Parameters); public virtual DataSet ExecuteDataSet(string tablename,
string sql, Object[] parameters); public virtual DataSet ExecuteDataSet(DataSet dataSet,
string tableName, DbCommand command, Object[] parameters); public virtual DataSet ExecuteDataSet(DataSet dataSet,
string tablename, string sql, Object[] parameters); |
|
ExecuteDynamicDataReader | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual object ExecuteDynamicDataReader(string sql,
Object[] parameters); |
|
ExecuteNonQuery | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual int ExecuteNonQuery(DbCommand Command);
public virtual int ExecuteNonQuery(string sql,
Object[] parameters); |
|
ExecuteReader | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual DbDataReader ExecuteReader(DbCommand command,
Object[] parameters); public virtual DbDataReader ExecuteReader(string sql,
Object[] parameters); |
|
ExecuteScalar | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual object ExecuteScalar(DbCommand command,
Object[] parameters); public virtual object ExecuteScalar(string sql,
Object[] parameters); |
|
ExecuteStoredProcedureNonQuery | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual int ExecuteStoredProcedureNonQuery(string storedProc,
Object[] parameters); |
|
ExecuteStoredProcedureReader | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual DbDataReader ExecuteStoredProcedureReader(string storedProc,
Object[] parameters); |
|
ExecuteStoredProcedureReader<T> | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual IEnumerable<T> ExecuteStoredProcedureReader<T>(string storedProc,
Object[] parameters); |
|
ExecuteTable | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual DataTable ExecuteTable(string tablename,
DbCommand command, Object[] parameters); public virtual DataTable ExecuteTable(string Tablename,
string Sql, Object[] Parameters); |
|
Find<T> | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual T Find<T>(object keyValue,
string tableName, string keyField); public virtual T Find<T>(string sql,
Object[] parameters); |
|
FindEx<T> | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual T FindEx<T>(string sql,
string fieldsToSkip, Object[] parameters); |
|
GetConnectionInfo | Inherited from Westwind.Utilities.Data.DataAccessBase public void GetConnectionInfo(string connectionString,
string providerName); |
|
GetEntity | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual bool GetEntity(object entity,
DbCommand command, string fieldsToSkip); public bool GetEntity(object entity,
string sql, Object[] parameters); public virtual bool GetEntity(object Entity,
string Table, string KeyField, object KeyValue, string FieldsToSkip); |
|
GetHashCode | Inherited from System.Object public virtual int GetHashCode();
|
|
GetType | Inherited from System.Object public Type GetType();
|
|
InsertEntity | Inherited from Westwind.Utilities.Data.DataAccessBase public object InsertEntity(object entity,
string table, string fieldsToSkip, bool returnIdentityKey); |
|
OpenConnection | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual bool OpenConnection();
|
|
Query<T> | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual IEnumerable<T> Query<T>(string sql,
Object[] parameters); public virtual IEnumerable<T> Query<T>(DbCommand command,
Object[] parameters); |
|
QueryWithExclusions<T> | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual IEnumerable<T> QueryWithExclusions<T>(string sql,
string propertiesToExclude, Object[] parameters); public virtual IEnumerable<T> QueryWithExclusions<T>(DbCommand sqlCommand,
string propertiesToExclude, Object[] parameters); |
|
RollbackTransaction | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual bool RollbackTransaction();
|
|
RunSqlScript | Inherited from Westwind.Utilities.Data.DataAccessBase public bool RunSqlScript(string script,
bool continueOnError, bool scriptIsFile); |
|
SaveEntity | Inherited from Westwind.Utilities.Data.DataAccessBase public virtual bool SaveEntity(object entity,
string table, string keyField, string fieldsToSkip); |
|
ToString | Inherited from System.Object public virtual string ToString();
|
|
UpdateEntity | Inherited from Westwind.Utilities.Data.DataAccessBase 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 | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
ConnectionString | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
ErrorMessage | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
ErrorNumber | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
ExecuteWithSchema | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
ParameterPrefix | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
Timeout | Inherited from Westwind.Utilities.Data.DataAccessBase |
|
Transaction | Inherited from Westwind.Utilities.Data.DataAccessBase |