void InspectSchema() { var dbInspector = new DbInspector(); dbInspector.LoadFromConfig(); if (dbInspector.SchemaInfo.Tables.Count == 0) { dbInspector.GenerateFromDb("AppDb"); } Application["SchemaInfo"] = dbInspector.SchemaInfo; }
private void connectButton_Click(object sender, EventArgs e) { sqlConnBuilder = loginControl.GetConnectionStringBuilder(); inspector = DbInspector.GetInstance(sqlConnBuilder); try { serverStructure = inspector.InitStructure(); inspector.LoadData(); dbComboBox.DataSource = serverStructure.Databases; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }
static void Main(string[] args) { Console.WriteLine("Meta Data Generator for DotWeb. Version " + Assembly.GetExecutingAssembly().GetName().Version); if (ConfigurationManager.ConnectionStrings["AppDb"] == null || ConfigurationManager.ConnectionStrings["DotWebDb"] == null) { Console.WriteLine("ERROR: missing connection string name AppDb or DotWebDb in configuration file. Please fix!"); } if (ConfigurationManager.AppSettings["appId"] == null) { Console.WriteLine("ERROR: missing appSettings appId key in configuration file. Please fix!"); } var dbInspector = new DbInspector(); dbInspector.GenerateFromDb("AppDb"); Console.WriteLine("DONE. Press any key to exit this application."); Console.ReadKey(); }
public void AutoExploreTest() { SystemMapEntities smdb = new SystemMapEntities(); string dbstring = smdb.Database.Connection.ConnectionString; SqlConnectionStringBuilder cbuilder = new SqlConnectionStringBuilder(dbstring); DbInspector sqlInspector = DbInspector.GetInstance(cbuilder); DataServerStructure serverData = sqlInspector.InitStructure(); sqlInspector.LoadData(); Assert.IsTrue(serverData.Databases.Count > 0); foreach (DataSourceStructure dbstruct in serverData.Databases) { if (dbstruct.DataSource.Name.Equals("SystemMap")) { sqlInspector.LoadDataSource(dbstruct); Assert.IsTrue(dbstruct.Nodes.Count > 0); Assert.IsTrue(dbstruct.Relationships.Count > 0); } } }