public ObservableCollection<DbTable> GetTables(DbConnectionInfo connectionInfo) { var extractor = new SchemaExtractor(); var tabledict = extractor.GetTables(connectionInfo); var tables = from t in tabledict.Values orderby t.Name select t; return new ObservableCollection<DbTable>(tables); }
public void LoadSchemaObjects(ICollection<SchemaObject> objectList, DbConnectionInfo connectionInfo) { var extractor = new SchemaExtractor(); objectList.Clear(); var tables = extractor.GetTables(connectionInfo); var columns = extractor.GetTableColumns(connectionInfo); AddColumns(tables, columns); var sortedTables = from t in tables.Values orderby t.Name select t; foreach (var t in sortedTables) objectList.Add(t); }