public class SqlDataAccess : DataAccessBase
Member | Description | |
---|---|---|
Constructor | ||
CloseConnection | Closes a connection public virtual void CloseConnection(DbCommand Command);
public virtual void CloseConnection();
|
|
CreateCommand | Creates a Command object and opens a connection public virtual DbCommand CreateCommand(string sql,
CommandType commandType, 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 | Creates a Sql Parameter for the specific provider public virtual DbParameter CreateParameter(string parameterName,
object value); |
|
ExecuteDataSet | Returns a DataTable from a Sql Command string passed in. public virtual DataSet ExecuteDataSet(DataSet dataSet,
string Tablename, DbCommand Command, DbParameter[] Parameters); public virtual DataSet ExecuteDataSet(string Tablename,
DbCommand Command, DbParameter[] Parameters); |
|
ExecuteNonQuery | Executes a non-query command and returns the affected records public virtual int ExecuteNonQuery(DbCommand Command,
DbParameter[] Parameters); |
|
ExecuteReader | Executes a SQL Command object and returns a SqlDataReader object public virtual DbDataReader ExecuteReader(DbCommand Command,
DbParameter[] Parameters); |
|
ExecuteScalar | Executes a command and returns a scalar value from it public virtual 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 virtual DataTable ExecuteTable(string Tablename,
DbCommand Command, DbParameter[] Parameters); |
|
OpenConnection | Opens a Sql Connection based on the connection string. Called internally but externally accessible. Sets the internal _Connection property. public virtual bool OpenConnection();
|