C# Class SalarDbCodeGenerator.Schema.DbSchemaReaders.OracleSchemaEngine

Inheritance: ExSchemaEngine

显示文件 Open project: GitOffice/SalarDbCodeGenerator

Private Properties

Property	Type	Description
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

Public Methods

Method	Description
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

Private Methods

Method	Description
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

Method Details

Dispose() public method

public Dispose ( ) : void
return	void

FillSchema() public method

Reads full database schema

public FillSchema ( DbDatabase schemaDatabase ) : void
schemaDatabase	DbDatabase
return	void

GetDataProviderClassName() public method

public GetDataProviderClassName ( DataProviderClassNames providerClassName ) : string
providerClassName	DataProviderClassNames
return	string

OracleSchemaEngine() public method

public OracleSchemaEngine ( DbConnection dbConnection ) : System
dbConnection	System.Data.Common.DbConnection
return	System

ReadViewsTablesList() public method

Reads list of tables and views

public ReadViewsTablesList ( StringCollection &tables, StringCollection &views ) : void
tables	System.Collections.Specialized.StringCollection
views	System.Collections.Specialized.StringCollection
return	void