C# Class nHydrate.Generator.SqlSchemaToModel

Afficher le fichier Open project: nHydrate/nHydrate

Méthodes publiques

Méthode Description
GetCompanyName ( string connectionString ) : string
GetDatabaseCollation ( string connectionString ) : string
GetDatabaseName ( string connectionString ) : string
GetProjectFromSqlSchema ( nHydrateGeneratorProject project, string connectionString, bool refreshModel, bool assumeInheritance ) : bool

Load a database schema

GetProjectName ( string connectionString ) : string
GetSQLVersion ( string connectionString ) : SQLServerTypeConstants
GetTableCount ( string connectionString ) : int
GetTableDefinitionFromDatabase ( string connectionString, string tableName, ModelRoot root ) : IEnumerable
GetTableListFromDatabase ( string connectionString ) : IEnumerable
ImportModel ( ModelRoot currentGraph, ModelRoot newGraph, ImportModelSettings settings, List selectedTables, List selectedViews ) : ImportReturnConstants

Show a windows to refresh teh model from a database

IsSupportedSQLVersion ( string connectionString ) : bool
IsValidConnectionString ( string connectionString ) : bool
LoadRelations ( nHydrateGeneratorProject project, bool assumeInheritance, string connectionString ) : void
SetupNewProject ( nHydrateGeneratorProject project, string connectionString ) : void

Load a database schema

Private Methods

Méthode Description
CanUseExtendedProperty ( string connectionString ) : bool
GetSqlColumnInfoAuxForTable ( ) : string
GetSqlColumnsForTable ( ) : string
GetSqlColumnsForTable ( string tableName ) : string
GetSqlColumsDescription ( string tableName ) : string
GetSqlDatabaseTables ( ) : string
GetSqlForRelationships ( ) : string
GetSqlForStoredProcedures ( string spPrefix ) : string
GetSqlForStoredProceduresBody ( string spName, string connectionString ) : string
GetSqlForStoredProceduresParameters ( string spPrefix ) : string
GetSqlForViews ( ) : string
GetSqlForViewsColumns ( ) : string
GetSqlIndexesForTable ( ) : string
LoadStoredProcedures ( nHydrateGeneratorProject project, string connectionString ) : void
LoadViews ( nHydrateGeneratorProject project, string connectionString ) : void
SetupDefault ( Column field, string defaultvalue ) : void
UpdateRelations ( nHydrate newDatabase, nHydrate oldDatabase ) : void
UpdateTables ( nHydrate newDatabase, nHydrate oldDatabase, List selectedTables, ImportModelSettings settings ) : void
UpdateViews ( nHydrate newDatabase, nHydrate oldDatabase, List selectedViews, ImportModelSettings settings ) : void

Method Details

GetCompanyName() public static méthode

public static GetCompanyName ( string connectionString ) : string
connectionString string
Résultat string

GetDatabaseCollation() public static méthode

public static GetDatabaseCollation ( string connectionString ) : string
connectionString string
Résultat string

GetDatabaseName() public static méthode

public static GetDatabaseName ( string connectionString ) : string
connectionString string
Résultat string

GetProjectFromSqlSchema() public static méthode

Load a database schema
public static GetProjectFromSqlSchema ( nHydrateGeneratorProject project, string connectionString, bool refreshModel, bool assumeInheritance ) : bool
project nHydrateGeneratorProject The project object to load from database
connectionString string
refreshModel bool Determines whether to load all model controllers and other UI components
assumeInheritance bool
Résultat bool

GetProjectName() public static méthode

public static GetProjectName ( string connectionString ) : string
connectionString string
Résultat string

GetSQLVersion() public static méthode

public static GetSQLVersion ( string connectionString ) : SQLServerTypeConstants
connectionString string
Résultat SQLServerTypeConstants

GetTableCount() public static méthode

public static GetTableCount ( string connectionString ) : int
connectionString string
Résultat int

GetTableDefinitionFromDatabase() public static méthode

public static GetTableDefinitionFromDatabase ( string connectionString, string tableName, ModelRoot root ) : IEnumerable
connectionString string
tableName string
root nHydrate.Generator.Models.ModelRoot
Résultat IEnumerable

GetTableListFromDatabase() public static méthode

public static GetTableListFromDatabase ( string connectionString ) : IEnumerable
connectionString string
Résultat IEnumerable

ImportModel() public static méthode

Show a windows to refresh teh model from a database
public static ImportModel ( ModelRoot currentGraph, ModelRoot newGraph, ImportModelSettings settings, List selectedTables, List selectedViews ) : ImportReturnConstants
currentGraph nHydrate.Generator.Models.ModelRoot
newGraph nHydrate.Generator.Models.ModelRoot
settings ImportModelSettings
selectedTables List
selectedViews List
Résultat ImportReturnConstants

IsSupportedSQLVersion() public static méthode

public static IsSupportedSQLVersion ( string connectionString ) : bool
connectionString string
Résultat bool

IsValidConnectionString() public static méthode

public static IsValidConnectionString ( string connectionString ) : bool
connectionString string
Résultat bool

LoadRelations() public static méthode

public static LoadRelations ( nHydrateGeneratorProject project, bool assumeInheritance, string connectionString ) : void
project nHydrateGeneratorProject
assumeInheritance bool
connectionString string
Résultat void

SetupNewProject() public static méthode

Load a database schema
public static SetupNewProject ( nHydrateGeneratorProject project, string connectionString ) : void
project nHydrateGeneratorProject The project object to load from database
connectionString string
Résultat void