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