private IEnumerable<Table> LoadTables() { using (var adapter = new SqlDataAdapter("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA like @schema order by 1", Connection.ConnectionString)) { adapter.SelectCommand.Parameters.AddWithValue("@schema", Name); var dataTable = new TablesDataSet.TableDataTable(); adapter.Fill(dataTable); foreach (TablesDataSet.TableRow row in dataTable.Rows) { yield return new Table(this, row); } } }
private IEnumerable <Table> LoadTables() { using (var adapter = new SqlDataAdapter("select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA like @schema order by 1", Connection.ConnectionString)) { adapter.SelectCommand.Parameters.AddWithValue("@schema", Name); var dataTable = new TablesDataSet.TableDataTable(); adapter.Fill(dataTable); foreach (TablesDataSet.TableRow row in dataTable.Rows) { yield return(new Table(this, row)); } } }