C# Class EngineAgnosticLayerDbAccess.EalDbAccess

Static library used for synchronous reads from a database, agnostic of the type of database engine ( i.e., MS SQL, PostgreSQL, etc.. )

Show file Open project: MarkVSullivan/SobekCM-Web-Application

Public Methods

Method	Description
BeginExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : void	Execute an asynchronous non-query SQL statement or stored procedure
BeginExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : void	Execute an asynchronous non-query SQL statement or stored procedure
BeginExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : void	Execute an asynchronous non-query SQL statement or stored procedure
ExecuteDataReader ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : EngineAgnosticLayerDbAccess.EalDbReaderWrapper	Execute a SQL statement or stored procedure and return a data reader
ExecuteDataReader ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : EngineAgnosticLayerDbAccess.EalDbReaderWrapper	Execute a SQL statement or stored procedure and return a data reader
ExecuteDataReader ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : EngineAgnosticLayerDbAccess.EalDbReaderWrapper	Execute a SQL statement or stored procedure and return a data reader
ExecuteDataset ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : DataSet	Execute a SQL statement or stored procedure and return a DataSet
ExecuteDataset ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : DataSet	Execute a SQL statement or stored procedure and return a DataSet
ExecuteDataset ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : DataSet	Execute a SQL statement or stored procedure and return a DataSet
ExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : void	Execute a non-query SQL statement or stored procedure
ExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : void	Execute a non-query SQL statement or stored procedure
ExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : void	Execute a non-query SQL statement or stored procedure
Test ( EalDbTypeEnum DbType, string DbConnectionString ) : bool	Test to see if a connection string is valid and can be used to create a connection

Private Methods

Method	Description
sql_add_params_to_command ( SqlCommand SqlCommand, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : void
sql_add_params_to_command ( SqlCommand SqlCommand, List DbParameters ) : void
sql_copy_returned_values_back_to_params ( EngineAgnosticLayerDbAccess.EalDbReaderWrapper Wrapper, System.Data.SqlClient.SqlParameterCollection SqlParams, EngineAgnosticLayerDbAccess.EalDbParameter EalParams ) : void
sql_copy_returned_values_back_to_params ( EngineAgnosticLayerDbAccess.EalDbReaderWrapper Wrapper, System.Data.SqlClient.SqlParameterCollection SqlParams, List EalParams ) : void
sql_copy_returned_values_back_to_params ( System.Data.SqlClient.SqlParameterCollection SqlParams, EngineAgnosticLayerDbAccess.EalDbParameter EalParams ) : void
sql_copy_returned_values_back_to_params ( System.Data.SqlClient.SqlParameterCollection SqlParams, List EalParams ) : void

Method Details

BeginExecuteNonQuery() public static method

Execute an asynchronous non-query SQL statement or stored procedure

public static BeginExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : void
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
return	void

BeginExecuteNonQuery() public static method

Execute an asynchronous non-query SQL statement or stored procedure

public static BeginExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : void
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	EngineAgnosticLayerDbAccess.EalDbParameter	Parameters for the SQL statement
return	void

BeginExecuteNonQuery() public static method

Execute an asynchronous non-query SQL statement or stored procedure

public static BeginExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : void
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	List	Parameters for the SQL statement
return	void

ExecuteDataReader() public static method

Execute a SQL statement or stored procedure and return a data reader

public static ExecuteDataReader ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : EngineAgnosticLayerDbAccess.EalDbReaderWrapper
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
return	EngineAgnosticLayerDbAccess.EalDbReaderWrapper

ExecuteDataReader() public static method

Execute a SQL statement or stored procedure and return a data reader

public static ExecuteDataReader ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : EngineAgnosticLayerDbAccess.EalDbReaderWrapper
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	EngineAgnosticLayerDbAccess.EalDbParameter	Parameters for the SQL statement
return	EngineAgnosticLayerDbAccess.EalDbReaderWrapper

ExecuteDataReader() public static method

Execute a SQL statement or stored procedure and return a data reader

public static ExecuteDataReader ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : EngineAgnosticLayerDbAccess.EalDbReaderWrapper
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	List	Parameters for the SQL statement
return	EngineAgnosticLayerDbAccess.EalDbReaderWrapper

ExecuteDataset() public static method

Execute a SQL statement or stored procedure and return a DataSet

public static ExecuteDataset ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : DataSet
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
return	System.Data.DataSet

ExecuteDataset() public static method

Execute a SQL statement or stored procedure and return a DataSet

public static ExecuteDataset ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : DataSet
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	EngineAgnosticLayerDbAccess.EalDbParameter	Parameters for the SQL statement
return	System.Data.DataSet

ExecuteDataset() public static method

Execute a SQL statement or stored procedure and return a DataSet

public static ExecuteDataset ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : DataSet
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	List	Parameters for the SQL statement
return	System.Data.DataSet

ExecuteNonQuery() public static method

Execute a non-query SQL statement or stored procedure

public static ExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText ) : void
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
return	void

ExecuteNonQuery() public static method

Execute a non-query SQL statement or stored procedure

public static ExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, EngineAgnosticLayerDbAccess.EalDbParameter DbParameters ) : void
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	EngineAgnosticLayerDbAccess.EalDbParameter	Parameters for the SQL statement
return	void

ExecuteNonQuery() public static method

Execute a non-query SQL statement or stored procedure

public static ExecuteNonQuery ( EalDbTypeEnum DbType, string DbConnectionString, CommandType DbCommandType, string DbCommandText, List DbParameters ) : void
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
DbCommandType	CommandType	Database command type
DbCommandText	string	Text of the database command, or name of the stored procedure to run
DbParameters	List	Parameters for the SQL statement
return	void

Test() public static method

Test to see if a connection string is valid and can be used to create a connection

public static Test ( EalDbTypeEnum DbType, string DbConnectionString ) : bool
DbType	EalDbTypeEnum	Type of database ( i.e., MSSQL, PostgreSQL )
DbConnectionString	string	Database connection string
return	bool