C# 클래스 nHydrate.Core.SQLGeneration.SQLEmit

파일 보기 프로젝트 열기: nHydrate/nHydrate

공개 메소드들

메소드 설명
AppendColumnDefaultCreateSQL ( Column column, bool includeDrop = true ) : string
AppendColumnDefaultRemoveSql ( Column column ) : string
CreateFkName ( Relation relation ) : string
CreateIndexName ( Table table, Column column ) : string
GetDefaultValueConstraintName ( Column column ) : string
GetDetailSQLValue ( Column column ) : string
GetIndexColumns ( Table table, TableIndex index ) : Column>.Dictionary
GetIndexName ( Table table, TableIndex index ) : string
GetSQLCreateAuditTable ( ModelRoot model, Table table ) : string
GetSQLCreateFunction ( Function function, bool isInternal, EFVersionConstants efversion ) : string
GetSQLCreateIndex ( Table table, TableIndex index, bool includeDrop ) : string
GetSQLCreateStoredProc ( CustomStoredProcedure storedProcedure, bool isInternal ) : string
GetSQLCreateTable ( ModelRoot model, Table table ) : string
GetSQLCreateTableSecurityFunction ( Table table, ModelRoot model, bool isInternal ) : string
GetSQLDropIndex ( Table table, TableIndex index ) : string
GetSqlAddColumn ( Column column ) : string
GetSqlAddColumn ( Column column, bool useComment ) : string
GetSqlAddFK ( Relation relation ) : string
GetSqlCreateAuditPK ( Table table ) : string
GetSqlCreateColumnDefault ( ModelRoot model, Column column ) : string
GetSqlCreatePK ( Table table ) : string
GetSqlCreateTenantColumn ( ModelRoot model, Table table ) : string
GetSqlCreateView ( CustomView view, bool isInternal ) : string
GetSqlDropAuditPK ( Table table ) : string
GetSqlDropColumn ( ModelRoot model, Column column ) : string
GetSqlDropColumnDefault ( Column column, bool upgradeScript = false ) : string
GetSqlDropPK ( Table table ) : string
GetSqlDropTable ( Table t ) : string
GetSqlInsertStaticData ( Table table ) : string
GetSqlModifyColumn ( Column oldColumn, Column newColumn ) : string
GetSqlRemoveFK ( Relation relation ) : string
GetSqlRenameColumn ( Column oldColumn, Column newColumn ) : string
GetSqlRenameColumn ( string table, string oldColumn, string newColumn ) : string
GetSqlRenameTable ( Table oldTable, Table newTable ) : string
GetSqlTenantIndex ( ModelRoot model, Table table ) : string
GetSqlTenantView ( ModelRoot model, Table table, StringBuilder grantSB ) : string
GetSqlUpdateStaticData ( Table table ) : string

비공개 메소드들

메소드 설명
AppendChildTableColumns ( Relation relation ) : string
AppendColumnDefinition ( Column column, bool allowDefault, bool allowIdentity ) : string
AppendColumnDefinition ( Column column, bool allowDefault, bool allowIdentity, bool forceNull ) : string
AppendColumnDefinition ( Column column, bool allowDefault, bool allowIdentity, bool forceNull, bool allowFormula ) : string
AppendColumnDefinition ( Column column, bool allowDefault, bool allowIdentity, bool forceNull, bool allowFormula, bool allowComputed ) : string
AppendCreateAudit ( ModelRoot model, Table table, StringBuilder sb ) : void
AppendModifiedAudit ( ModelRoot model, Table table, StringBuilder sb ) : void
AppendParentTableColumns ( Relation relation, Table table ) : string
AppendTenantField ( ModelRoot model, Table table, StringBuilder sb ) : void
AppendTimestamp ( ModelRoot model, Table table, StringBuilder sb ) : void
BuildFunctionParameterList ( IEnumerable parameterList ) : string
BuildStoredProcParameterList ( CustomStoredProcedure storedProcedure ) : string
GetDefaultValue ( string modelDefault ) : string
GetDefaultValueClause ( Column column ) : string
GetFieldNames ( Relation relation ) : string
GetSQLCreateFunctionSPWrapper ( Function function ) : string

메소드 상세

AppendColumnDefaultCreateSQL() 공개 정적인 메소드

public static AppendColumnDefaultCreateSQL ( Column column, bool includeDrop = true ) : string
column nHydrate.Generator.Models.Column
includeDrop bool
리턴 string

AppendColumnDefaultRemoveSql() 공개 정적인 메소드

public static AppendColumnDefaultRemoveSql ( Column column ) : string
column nHydrate.Generator.Models.Column
리턴 string

CreateFkName() 공개 정적인 메소드

public static CreateFkName ( Relation relation ) : string
relation nHydrate.Generator.Models.Relation
리턴 string

CreateIndexName() 공개 정적인 메소드

public static CreateIndexName ( Table table, Column column ) : string
table nHydrate.Generator.Models.Table
column nHydrate.Generator.Models.Column
리턴 string

GetDefaultValueConstraintName() 공개 정적인 메소드

public static GetDefaultValueConstraintName ( Column column ) : string
column nHydrate.Generator.Models.Column
리턴 string

GetDetailSQLValue() 공개 정적인 메소드

public static GetDetailSQLValue ( Column column ) : string
column nHydrate.Generator.Models.Column
리턴 string

GetIndexColumns() 공개 정적인 메소드

public static GetIndexColumns ( Table table, TableIndex index ) : Column>.Dictionary
table nHydrate.Generator.Models.Table
index nHydrate.Generator.Models.TableIndex
리턴 Column>.Dictionary

GetIndexName() 공개 정적인 메소드

public static GetIndexName ( Table table, TableIndex index ) : string
table nHydrate.Generator.Models.Table
index nHydrate.Generator.Models.TableIndex
리턴 string

GetSQLCreateAuditTable() 공개 정적인 메소드

public static GetSQLCreateAuditTable ( ModelRoot model, Table table ) : string
model nHydrate.Generator.Models.ModelRoot
table nHydrate.Generator.Models.Table
리턴 string

GetSQLCreateFunction() 공개 정적인 메소드

public static GetSQLCreateFunction ( Function function, bool isInternal, EFVersionConstants efversion ) : string
function Function
isInternal bool
efversion EFVersionConstants
리턴 string

GetSQLCreateIndex() 공개 정적인 메소드

public static GetSQLCreateIndex ( Table table, TableIndex index, bool includeDrop ) : string
table nHydrate.Generator.Models.Table
index nHydrate.Generator.Models.TableIndex
includeDrop bool
리턴 string

GetSQLCreateStoredProc() 공개 정적인 메소드

public static GetSQLCreateStoredProc ( CustomStoredProcedure storedProcedure, bool isInternal ) : string
storedProcedure nHydrate.Generator.Models.CustomStoredProcedure
isInternal bool
리턴 string

GetSQLCreateTable() 공개 정적인 메소드

public static GetSQLCreateTable ( ModelRoot model, Table table ) : string
model nHydrate.Generator.Models.ModelRoot
table nHydrate.Generator.Models.Table
리턴 string

GetSQLCreateTableSecurityFunction() 공개 정적인 메소드

public static GetSQLCreateTableSecurityFunction ( Table table, ModelRoot model, bool isInternal ) : string
table nHydrate.Generator.Models.Table
model nHydrate.Generator.Models.ModelRoot
isInternal bool
리턴 string

GetSQLDropIndex() 공개 정적인 메소드

public static GetSQLDropIndex ( Table table, TableIndex index ) : string
table nHydrate.Generator.Models.Table
index nHydrate.Generator.Models.TableIndex
리턴 string

GetSqlAddColumn() 공개 정적인 메소드

public static GetSqlAddColumn ( Column column ) : string
column nHydrate.Generator.Models.Column
리턴 string

GetSqlAddColumn() 공개 정적인 메소드

public static GetSqlAddColumn ( Column column, bool useComment ) : string
column nHydrate.Generator.Models.Column
useComment bool
리턴 string

GetSqlAddFK() 공개 정적인 메소드

public static GetSqlAddFK ( Relation relation ) : string
relation nHydrate.Generator.Models.Relation
리턴 string

GetSqlCreateAuditPK() 공개 정적인 메소드

public static GetSqlCreateAuditPK ( Table table ) : string
table nHydrate.Generator.Models.Table
리턴 string

GetSqlCreateColumnDefault() 공개 정적인 메소드

public static GetSqlCreateColumnDefault ( ModelRoot model, Column column ) : string
model nHydrate.Generator.Models.ModelRoot
column nHydrate.Generator.Models.Column
리턴 string

GetSqlCreatePK() 공개 정적인 메소드

public static GetSqlCreatePK ( Table table ) : string
table nHydrate.Generator.Models.Table
리턴 string

GetSqlCreateTenantColumn() 공개 정적인 메소드

public static GetSqlCreateTenantColumn ( ModelRoot model, Table table ) : string
model nHydrate.Generator.Models.ModelRoot
table nHydrate.Generator.Models.Table
리턴 string

GetSqlCreateView() 공개 정적인 메소드

public static GetSqlCreateView ( CustomView view, bool isInternal ) : string
view nHydrate.Generator.Models.CustomView
isInternal bool
리턴 string

GetSqlDropAuditPK() 공개 정적인 메소드

public static GetSqlDropAuditPK ( Table table ) : string
table nHydrate.Generator.Models.Table
리턴 string

GetSqlDropColumn() 공개 정적인 메소드

public static GetSqlDropColumn ( ModelRoot model, Column column ) : string
model nHydrate.Generator.Models.ModelRoot
column nHydrate.Generator.Models.Column
리턴 string

GetSqlDropColumnDefault() 공개 정적인 메소드

public static GetSqlDropColumnDefault ( Column column, bool upgradeScript = false ) : string
column nHydrate.Generator.Models.Column
upgradeScript bool
리턴 string

GetSqlDropPK() 공개 정적인 메소드

public static GetSqlDropPK ( Table table ) : string
table nHydrate.Generator.Models.Table
리턴 string

GetSqlDropTable() 공개 정적인 메소드

public static GetSqlDropTable ( Table t ) : string
t nHydrate.Generator.Models.Table
리턴 string

GetSqlInsertStaticData() 공개 정적인 메소드

public static GetSqlInsertStaticData ( Table table ) : string
table nHydrate.Generator.Models.Table
리턴 string

GetSqlModifyColumn() 공개 정적인 메소드

public static GetSqlModifyColumn ( Column oldColumn, Column newColumn ) : string
oldColumn nHydrate.Generator.Models.Column
newColumn nHydrate.Generator.Models.Column
리턴 string

GetSqlRemoveFK() 공개 정적인 메소드

public static GetSqlRemoveFK ( Relation relation ) : string
relation nHydrate.Generator.Models.Relation
리턴 string

GetSqlRenameColumn() 공개 정적인 메소드

public static GetSqlRenameColumn ( Column oldColumn, Column newColumn ) : string
oldColumn nHydrate.Generator.Models.Column
newColumn nHydrate.Generator.Models.Column
리턴 string

GetSqlRenameColumn() 공개 정적인 메소드

public static GetSqlRenameColumn ( string table, string oldColumn, string newColumn ) : string
table string
oldColumn string
newColumn string
리턴 string

GetSqlRenameTable() 공개 정적인 메소드

public static GetSqlRenameTable ( Table oldTable, Table newTable ) : string
oldTable nHydrate.Generator.Models.Table
newTable nHydrate.Generator.Models.Table
리턴 string

GetSqlTenantIndex() 공개 정적인 메소드

public static GetSqlTenantIndex ( ModelRoot model, Table table ) : string
model nHydrate.Generator.Models.ModelRoot
table nHydrate.Generator.Models.Table
리턴 string

GetSqlTenantView() 공개 정적인 메소드

public static GetSqlTenantView ( ModelRoot model, Table table, StringBuilder grantSB ) : string
model nHydrate.Generator.Models.ModelRoot
table nHydrate.Generator.Models.Table
grantSB StringBuilder
리턴 string

GetSqlUpdateStaticData() 공개 정적인 메소드

public static GetSqlUpdateStaticData ( Table table ) : string
table nHydrate.Generator.Models.Table
리턴 string