C# Класс EngineAgnosticLayerDbAccess.EalDbAccess

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

Показать файл Открыть проект

Открытые методы

Метод	Описание
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

Приватные методы

Метод	Описание
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

Описание методов

BeginExecuteNonQuery() публичный статический Метод

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
Результат	void

BeginExecuteNonQuery() публичный статический Метод

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
Результат	void

BeginExecuteNonQuery() публичный статический Метод

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
Результат	void

ExecuteDataReader() публичный статический Метод

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
Результат	EngineAgnosticLayerDbAccess.EalDbReaderWrapper

ExecuteDataReader() публичный статический Метод

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
Результат	EngineAgnosticLayerDbAccess.EalDbReaderWrapper

ExecuteDataReader() публичный статический Метод

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
Результат	EngineAgnosticLayerDbAccess.EalDbReaderWrapper

ExecuteDataset() публичный статический Метод

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
Результат	System.Data.DataSet

ExecuteDataset() публичный статический Метод

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
Результат	System.Data.DataSet

ExecuteDataset() публичный статический Метод

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
Результат	System.Data.DataSet

ExecuteNonQuery() публичный статический Метод

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
Результат	void

ExecuteNonQuery() публичный статический Метод

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
Результат	void

ExecuteNonQuery() публичный статический Метод

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
Результат	void

Test() публичный статический Метод

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
Результат	bool