C# Класс SalarDbCodeGenerator.Schema.DbSchemaReaders.OracleSchemaEngine

Наследование: ExSchemaEngine
Показать файл Открыть проект

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