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.. )

파일 보기 프로젝트 열기: MarkVSullivan/SobekCM-Web-Application

공개 메소드들

메소드	설명
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