public static void UpdateTable(string connString, string dbName)
{
var schema = new DbSchema(connString);
_builder = new BuilderBL.SQLDesigner.QueryBuilder(schema);
var newGroup = new Group {
Name = dbName, SubGroups = new List <Group>(), Entries = new List <Entry>()
};
if (schema != null)
{
foreach (var dt in schema.GetTableEntities(schema))
{
var temp = new Group {
Name = dt.Key, SubGroups = new List <Group>(), Entries = new List <Entry>()
};
foreach (var entry in dt.Value)
{
temp.Entries.Add(new Entry()
{
Name = entry, Parent = dt.Key
});
}
newGroup.SubGroups.Add(temp);
}
MainWindowData.UserConnections.Add(newGroup);
}
}
public static void UpdateTable(string connString, string dbName)
{
var schema = new DbSchema(connString);
_builder = new BuilderBL.SQLDesigner.QueryBuilder(schema);
var newGroup = new Group { Name = dbName, SubGroups = new List<Group>(), Entries = new List<Entry>() };
if (schema != null)
{
foreach (var dt in schema.GetTableEntities(schema))
{
var temp = new Group { Name = dt.Key, SubGroups = new List<Group>(), Entries = new List<Entry>() };
foreach (var entry in dt.Value)
{
temp.Entries.Add(new Entry() { Name = entry, Parent = dt.Key });
}
newGroup.SubGroups.Add(temp);
}
MainWindowData.UserConnections.Add(newGroup);
}
}