C# Class dbfit.SqlServerEnvironment

Implementation of IDbEnvironment that works with SqlServer 2005 and newer versions

Inheritance: AbstractDbEnvironment

Show file Open project: jediwhale/fitsharp Class Usage Examples

Public Methods

Method	Description
GetAllColumns ( String tableOrViewName ) : DbParameterAccessor>.Dictionary
GetAllProcedureParameters ( String procName ) : DbParameterAccessor>.Dictionary
GetExceptionCode ( Exception dbException ) : int
IdentitySelectStatement ( string tableName ) : String

Protected Methods

Method	Description
BuildColumnName ( string sourceColumnName ) : string
GetConnectionString ( String dataSource, String username, String password ) : String
GetConnectionString ( String dataSource, String username, String password, String databaseName ) : String
GetDBType ( String dataType ) : SqlDbType
GetDotNetType ( String dataType ) : Type

Private Methods

Method	Description
GetDbName ( String objectName ) : string
GetParameterDirection ( int isOutput ) : ParameterDirection
NormaliseTypeName ( string dataType ) : string
ReadIntoParams ( String objname, String query ) : DbParameterAccessor>.Dictionary

Method Details

BuildColumnName() protected method

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

GetAllColumns() public method

public GetAllColumns ( String tableOrViewName ) : DbParameterAccessor>.Dictionary
tableOrViewName	String
return	DbParameterAccessor>.Dictionary

GetAllProcedureParameters() public method

public GetAllProcedureParameters ( String procName ) : DbParameterAccessor>.Dictionary
procName	String
return	DbParameterAccessor>.Dictionary

GetConnectionString() protected method

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

GetConnectionString() protected method

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

GetDBType() protected static method

protected static GetDBType ( String dataType ) : SqlDbType
dataType	String
return	SqlDbType

GetDotNetType() protected static method

protected static GetDotNetType ( String dataType ) : Type
dataType	String
return	System.Type

GetExceptionCode() public method

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

IdentitySelectStatement() public method

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