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);
}
}
}
