• Inicio
• SalarDbCodeGenerator
• Schema
• DbSchemaReaders
• SQLSchemaEngine

C# Class SalarDbCodeGenerator.Schema.DbSchemaReaders.SQLSchemaEngine

Mostrar archivo Open project: GitOffice/SalarDbCodeGenerator

Public Methods

Method	Description
Dispose ( ) : void
FillSchema ( DbDatabase schemaDatabase ) : void	Reads full database schema
GetDataProviderClassName ( DataProviderClassNames providerClassName ) : string
ReadViewsTablesList ( StringCollection &tables, StringCollection &views ) : void	Reads list of tables and views
SQLSchemaEngine ( DbConnection dbConnection ) : System

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, SQLServerVersions sqlVersion ) : void	Reads tables index keys
ApplyTablesForeignKeys ( List tables, SQLServerVersions sqlServer ) : void	Reads specified table foreign keys.
ConvertSqlServerForeignKeyAction ( int actionCode ) : DbForeignKeyAction
DetectSqlServerVersion ( DbConnection conn ) : SQLServerVersions	Detecting sql server version
FillColumnAdditionalInfo ( DbColumn toSetColumn, DataTable columnsDbTypeTable, string tableName, string columnName ) : bool	Column additional information
FindTable ( List tables, string tableName ) : DbTable	Finds table from list
GetColumnDbDataType ( DataTable columnsDbTypeTable, string tableName, string columnName ) : string	Column DBType name
NormalizeTablesConstraintKeys ( List result, SQLServerVersions sqlVersion ) : void	Removes duplicate table constraints, PK > UK > IX
ReadColumns ( String tableName, string ownerName ) : 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