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