C# 클래스 SalarDbCodeGenerator.Schema.DbSchemaReaders.OracleSchemaEngine

상속: ExSchemaEngine
파일 보기 프로젝트 열기: GitOffice/SalarDbCodeGenerator

Private Properties

프로퍼티 타입 설명
ApplyColumnsDescription void
ApplyDetectedOneToOneRelation void
ApplyTablesConstraintKeys void
ApplyTablesForeignKeys void
AssignCaseSensitiveTablesName void
ConvertOracleForeignKeyAction DbForeignKeyAction
DetectVersion OracleServerVersions
FillColumnAdditionalInfo void
FindMatchingDotNetDataType string
FindTable DbTable
GetColumnDbDataType string
NormalizeTablesConstraintKeys void
ReadColumns List
ReadTables List
ReadTablesList System.Collections.Specialized.StringCollection
ReadViews List
ReadViewsList System.Collections.Specialized.StringCollection

공개 메소드들

메소드 설명
Dispose ( ) : void
FillSchema ( DbDatabase schemaDatabase ) : void

Reads full database schema

GetDataProviderClassName ( DataProviderClassNames providerClassName ) : string
OracleSchemaEngine ( DbConnection dbConnection ) : System
ReadViewsTablesList ( StringCollection &tables, StringCollection &views ) : void

Reads list of tables and views

비공개 메소드들

메소드 설명
ApplyColumnsDescription ( string tableName, List columns ) : void

Reads columns description from SQLServer

ApplyDetectedOneToOneRelation ( List tables ) : void

Detecting one-to-one relation

ApplyTablesConstraintKeys ( List tables, OracleServerVersions sqlVersion ) : void

Reads tables index keys

ApplyTablesForeignKeys ( List tables ) : void

Reads specified table foreign keys.

AssignCaseSensitiveTablesName ( List tables ) : void

Only oracle allows case sensitive table names!

ConvertOracleForeignKeyAction ( string action ) : DbForeignKeyAction
DetectVersion ( DbConnection conn ) : OracleServerVersions

Detecting oracle version

FillColumnAdditionalInfo ( DbColumn toSetColumn, string tableName, string columnName ) : void

Column additional information

FindMatchingDotNetDataType ( string dataType ) : string

Converting oracle datatype to DotNet usable datatype

FindTable ( List tables, string tableName ) : DbTable

Finds table from list

GetColumnDbDataType ( DataTable columnsDbTypeTable, string tableName, string columnName ) : string

Column DBType name

NormalizeTablesConstraintKeys ( List result, OracleServerVersions sqlVersion ) : void

Removes duplicate table constraints, PK > UK > IX

ReadColumns ( String tableName ) : List

Read columns schema from database

ReadTables ( List viewList ) : List

Reads tables schema from database

ReadTablesList ( StringCollection viewsList ) : StringCollection

Reads tables list. This method requires views list to prevent from conflict!

ReadViews ( ) : List

Reads views schema from database

ReadViewsList ( ) : StringCollection

Reads views list

메소드 상세

Dispose() 공개 메소드

public Dispose ( ) : void
리턴 void

FillSchema() 공개 메소드

Reads full database schema
public FillSchema ( DbDatabase schemaDatabase ) : void
schemaDatabase DbDatabase
리턴 void

GetDataProviderClassName() 공개 메소드

public GetDataProviderClassName ( DataProviderClassNames providerClassName ) : string
providerClassName DataProviderClassNames
리턴 string

OracleSchemaEngine() 공개 메소드

public OracleSchemaEngine ( DbConnection dbConnection ) : System
dbConnection System.Data.Common.DbConnection
리턴 System

ReadViewsTablesList() 공개 메소드

Reads list of tables and views
public ReadViewsTablesList ( StringCollection &tables, StringCollection &views ) : void
tables System.Collections.Specialized.StringCollection
views System.Collections.Specialized.StringCollection
리턴 void