C# Class dbfit.AbstractDbEnvironment

Utility class to simplify development of IDbEnvironment implementations. This class has implementations for methods that will be common across most databases. It also provides default accessors for the current connection and transaction.

Inheritance: IDbEnvironment

Mostrar archivo Open project: jediwhale/fitsharp

Public Methods

Method	Description
BindFixtureSymbols ( Symbols symbols, DbCommand dc ) : void
BuildInsertCommand ( String tableName, dbfit.DbParameterAccessor accessors ) : String
BuildUpdateCommand ( String tableName, dbfit.DbParameterAccessor updateAccessors, dbfit.DbParameterAccessor selectAccessors ) : String
CloseConnection ( ) : void
Commit ( ) : void
Connect ( String connectionString ) : void
Connect ( String dataSource, String username, String password ) : void
Connect ( String dataSource, String username, String password, String database ) : void
ConnectNoTransaction ( String dataSource, String username, String password, String database ) : void
ConnectUsingConfig ( string connectionName ) : void
ConnectUsingFile ( String connectionPropertiesFile ) : void
CreateCommand ( string statement, CommandType commandType ) : DbCommand
ExtractParamNames ( string commandText ) : string[]
GetAllColumns ( string tableOrViewName ) : DbParameterAccessor>.Dictionary
GetAllProcedureParameters ( string procName ) : DbParameterAccessor>.Dictionary
GetExceptionCode ( Exception dbException ) : int
IdentitySelectStatement ( String tableName ) : String
Rollback ( ) : void

Protected Methods

Method	Description
AddInput ( DbCommand dbCommand, String name, Object value ) : void
BuildColumnName ( string sourceColumnName ) : string
GetConnectionString ( String dataSource, String username, String password ) : String
GetConnectionString ( String dataSource, String username, String password, String database ) : String

Method Details

AddInput() protected method

protected AddInput ( DbCommand dbCommand, String name, Object value ) : void
dbCommand	System.Data.Common.DbCommand
name	String
value	Object
return	void

BindFixtureSymbols() public method

public BindFixtureSymbols ( Symbols symbols, DbCommand dc ) : void
symbols	Symbols
dc	System.Data.Common.DbCommand
return	void

BuildColumnName() protected method

protected BuildColumnName ( string sourceColumnName ) : string
sourceColumnName	string
return	string

BuildInsertCommand() public method

public BuildInsertCommand ( String tableName, dbfit.DbParameterAccessor accessors ) : String
tableName	String
accessors	dbfit.DbParameterAccessor
return	String

BuildUpdateCommand() public method

public BuildUpdateCommand ( String tableName, dbfit.DbParameterAccessor updateAccessors, dbfit.DbParameterAccessor selectAccessors ) : String
tableName	String
updateAccessors	dbfit.DbParameterAccessor
selectAccessors	dbfit.DbParameterAccessor
return	String

CloseConnection() public method

public CloseConnection ( ) : void
return	void

Commit() public method

public Commit ( ) : void
return	void

Connect() public method

public Connect ( String connectionString ) : void
connectionString	String
return	void

Connect() public method

public Connect ( String dataSource, String username, String password ) : void
dataSource	String
username	String
password	String
return	void

Connect() public method

public Connect ( String dataSource, String username, String password, String database ) : void
dataSource	String
username	String
password	String
database	String
return	void

ConnectNoTransaction() public method

public ConnectNoTransaction ( String dataSource, String username, String password, String database ) : void
dataSource	String
username	String
password	String
database	String
return	void

ConnectUsingConfig() public method

public ConnectUsingConfig ( string connectionName ) : void
connectionName	string
return	void

ConnectUsingFile() public method

public ConnectUsingFile ( String connectionPropertiesFile ) : void
connectionPropertiesFile	String
return	void

CreateCommand() public method

public CreateCommand ( string statement, CommandType commandType ) : DbCommand
statement	string
commandType	CommandType
return	System.Data.Common.DbCommand

ExtractParamNames() public method

public ExtractParamNames ( string commandText ) : string[]
commandText	string
return	string[]

GetAllColumns() public abstract method

public abstract GetAllColumns ( string tableOrViewName ) : DbParameterAccessor>.Dictionary
tableOrViewName	string
return	DbParameterAccessor>.Dictionary

GetAllProcedureParameters() public abstract method

public abstract GetAllProcedureParameters ( string procName ) : DbParameterAccessor>.Dictionary
procName	string
return	DbParameterAccessor>.Dictionary

GetConnectionString() protected abstract method

protected abstract GetConnectionString ( String dataSource, String username, String password ) : String
dataSource	String
username	String
password	String
return	String

GetConnectionString() protected abstract method

protected abstract GetConnectionString ( String dataSource, String username, String password, String database ) : String
dataSource	String
username	String
password	String
database	String
return	String

GetExceptionCode() public method

public GetExceptionCode ( Exception dbException ) : int
dbException	System.Exception
return	int

IdentitySelectStatement() public abstract method

public abstract IdentitySelectStatement ( String tableName ) : String
tableName	String
return	String

Rollback() public method

public Rollback ( ) : void
return	void