C# Class CodeKing.SqlHarvester.Data.Database

A datalayer used for excecuting commands on the database.

Inheritance: IDataCommand

Afficher le fichier Open project: TheCodeKing/SqlHarvester.Net

Méthodes publiques

Méthode	Description
AddParameterWithValue ( IDbCommand command, string name, object value ) : void	Adds the parameter with value to the given command. This is becuase IDbCommand does not include the AddWithValue method.
BeginTransaction ( ) : void	Begins a new active transaction.
Commit ( ) : void	Commits the active transaction.
CreateCommand ( string commandText ) : IDbCommand	Creates the concrete command instance to use with this implementation.
Database ( ) : System.Data	Initializes a new instance of the DatabaseAccess class.
Database ( string connectionString ) : System.Data	Initializes a new instance of the DatabaseAccess class.
Database ( string connectionString, int connectionTimeout ) : System.Data	Initializes a new instance of the DatabaseAccess class.
Dispose ( ) : void	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
ExecuteNonQuery ( IDbCommand cmd ) : int	Executes the non query
ExecuteReader ( IDbCommand cmd ) : IDataReader	Executes the reader.
ExecuteScalar ( IDbCommand cmd ) : object	Executes the scalar.
GetConnection ( ) : IDbConnection	Gets the connection.
GetConnection ( IDbCommand cmd ) : IDbConnection	Gets the connection.
Rollback ( ) : void	Rollback the active transaction.

Private Methods

Méthode	Description
GetConnectionCheckTransaction ( ) : IDbConnection

Method Details

AddParameterWithValue() public méthode

Adds the parameter with value to the given command. This is becuase IDbCommand does not include the AddWithValue method.

public AddParameterWithValue ( IDbCommand command, string name, object value ) : void
command	IDbCommand	The command.
name	string	The name.
value	object	The value.
Résultat	void

BeginTransaction() public méthode

Begins a new active transaction.

public BeginTransaction ( ) : void
Résultat	void

Commit() public méthode

Commits the active transaction.

public Commit ( ) : void
Résultat	void

CreateCommand() public méthode

Creates the concrete command instance to use with this implementation.

public CreateCommand ( string commandText ) : IDbCommand
commandText	string	The command text.
Résultat	IDbCommand

Database() public méthode

Initializes a new instance of the DatabaseAccess class.

public Database ( ) : System.Data
Résultat	System.Data

Database() public méthode

Initializes a new instance of the DatabaseAccess class.

public Database ( string connectionString ) : System.Data
connectionString	string	The connection string.
Résultat	System.Data

Database() public méthode

Initializes a new instance of the DatabaseAccess class.

public Database ( string connectionString, int connectionTimeout ) : System.Data
connectionString	string	The connection string.
connectionTimeout	int	The connection timeout.
Résultat	System.Data

Dispose() public méthode

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

public Dispose ( ) : void
Résultat	void

ExecuteNonQuery() public méthode

Executes the non query

public ExecuteNonQuery ( IDbCommand cmd ) : int
cmd	IDbCommand	The CMD.
Résultat	int

ExecuteReader() public méthode

Executes the reader.

public ExecuteReader ( IDbCommand cmd ) : IDataReader
cmd	IDbCommand	The CMD.
Résultat	IDataReader

ExecuteScalar() public méthode

Executes the scalar.

public ExecuteScalar ( IDbCommand cmd ) : object
cmd	IDbCommand	The CMD.
Résultat	object

GetConnection() public méthode

Gets the connection.

public GetConnection ( ) : IDbConnection
Résultat	IDbConnection

GetConnection() public méthode

Gets the connection.

public GetConnection ( IDbCommand cmd ) : IDbConnection
cmd	IDbCommand	The CMD.
Résultat	IDbConnection

Rollback() public méthode

Rollback the active transaction.

public Rollback ( ) : void
Résultat	void