C# Class Dashing.Engine.Dialects.SqlDialectBase

Inheritance: ISqlDialect
Show file Open project: Polylytics/dashing

Public Methods

Method Description
AppendColumnSpecification ( StringBuilder sql, IColumn column, bool scriptDefault = true ) : void
AppendEscaped ( StringBuilder sql, string s ) : void
AppendForUpdateOnQueryFinish ( StringBuilder sql ) : void
AppendForUpdateUsingTableHint ( StringBuilder tableSql ) : void
AppendQuotedName ( StringBuilder sql, string name ) : void
AppendQuotedTableName ( StringBuilder sql, IMap map ) : void
ApplySkipTake ( StringBuilder sql, StringBuilder orderClause, int take, int skip ) : void
ChangeColumnName ( IColumn fromColumn, IColumn toColumn ) : string
ChangeTableName ( IMap @from, IMap to ) : string
CheckDatabaseExists ( string databaseName ) : string
CreateDatabase ( string databaseName ) : string
CreateForeignKey ( ForeignKey foreignKey ) : string
CreateIndex ( Index index ) : string
DropForeignKey ( ForeignKey foreignKey ) : string
DropIndex ( Index index ) : string
GetIdSql ( ) : string
ModifyColumn ( IColumn fromColumn, IColumn toColumn ) : string
OnBeforeDropColumn ( IColumn column ) : string
SqlDialectBase ( char beginQuoteCharacter = '"', char endQuoteCharacter = '"' ) : System
WriteDropTableIfExists ( string tableName ) : string

Protected Methods

Method Description
AppendAutoGenerateModifier ( StringBuilder sql, IColumn column ) : void
AppendColumnSpecificationWithoutName ( StringBuilder sql, IColumn column, bool scriptDefault = true ) : void
AppendDefault ( StringBuilder sql, IColumn column ) : void
AppendPrecisionAndScale ( StringBuilder sql, byte precision, byte scale ) : void
TypeName ( DbType type ) : string

Method Details

AppendAutoGenerateModifier() protected method

protected AppendAutoGenerateModifier ( StringBuilder sql, IColumn column ) : void
sql StringBuilder
column IColumn
return void

AppendColumnSpecification() public method

public AppendColumnSpecification ( StringBuilder sql, IColumn column, bool scriptDefault = true ) : void
sql StringBuilder
column IColumn
scriptDefault bool
return void

AppendColumnSpecificationWithoutName() protected method

protected AppendColumnSpecificationWithoutName ( StringBuilder sql, IColumn column, bool scriptDefault = true ) : void
sql StringBuilder
column IColumn
scriptDefault bool
return void

AppendDefault() protected method

protected AppendDefault ( StringBuilder sql, IColumn column ) : void
sql StringBuilder
column IColumn
return void

AppendEscaped() public method

public AppendEscaped ( StringBuilder sql, string s ) : void
sql StringBuilder
s string
return void

AppendForUpdateOnQueryFinish() public abstract method

public abstract AppendForUpdateOnQueryFinish ( StringBuilder sql ) : void
sql StringBuilder
return void

AppendForUpdateUsingTableHint() public abstract method

public abstract AppendForUpdateUsingTableHint ( StringBuilder tableSql ) : void
tableSql StringBuilder
return void

AppendPrecisionAndScale() protected method

protected AppendPrecisionAndScale ( StringBuilder sql, byte precision, byte scale ) : void
sql StringBuilder
precision byte
scale byte
return void

AppendQuotedName() public method

public AppendQuotedName ( StringBuilder sql, string name ) : void
sql StringBuilder
name string
return void

AppendQuotedTableName() public method

public AppendQuotedTableName ( StringBuilder sql, IMap map ) : void
sql StringBuilder
map IMap
return void

ApplySkipTake() public abstract method

public abstract ApplySkipTake ( StringBuilder sql, StringBuilder orderClause, int take, int skip ) : void
sql StringBuilder
orderClause StringBuilder
take int
skip int
return void

ChangeColumnName() public abstract method

public abstract ChangeColumnName ( IColumn fromColumn, IColumn toColumn ) : string
fromColumn IColumn
toColumn IColumn
return string

ChangeTableName() public abstract method

public abstract ChangeTableName ( IMap @from, IMap to ) : string
@from IMap
to IMap
return string

CheckDatabaseExists() public abstract method

public abstract CheckDatabaseExists ( string databaseName ) : string
databaseName string
return string

CreateDatabase() public method

public CreateDatabase ( string databaseName ) : string
databaseName string
return string

CreateForeignKey() public method

public CreateForeignKey ( ForeignKey foreignKey ) : string
foreignKey Dashing.Configuration.ForeignKey
return string

CreateIndex() public method

public CreateIndex ( Index index ) : string
index Dashing.Configuration.Index
return string

DropForeignKey() public abstract method

public abstract DropForeignKey ( ForeignKey foreignKey ) : string
foreignKey Dashing.Configuration.ForeignKey
return string

DropIndex() public abstract method

public abstract DropIndex ( Index index ) : string
index Dashing.Configuration.Index
return string

GetIdSql() public method

public GetIdSql ( ) : string
return string

ModifyColumn() public abstract method

public abstract ModifyColumn ( IColumn fromColumn, IColumn toColumn ) : string
fromColumn IColumn
toColumn IColumn
return string

OnBeforeDropColumn() public method

public OnBeforeDropColumn ( IColumn column ) : string
column IColumn
return string

SqlDialectBase() public method

public SqlDialectBase ( char beginQuoteCharacter = '"', char endQuoteCharacter = '"' ) : System
beginQuoteCharacter char
endQuoteCharacter char
return System

TypeName() protected method

protected TypeName ( DbType type ) : string
type DbType
return string

WriteDropTableIfExists() public method

public WriteDropTableIfExists ( string tableName ) : string
tableName string
return string