private IEnumerable <Column> LoadColumns()
{
using (var adapter = new SqlDataAdapter("select COLUMN_NAME, DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = @schema and TABLE_NAME = @table order by ORDINAL_POSITION", Schema.Connection.ConnectionString))
{
adapter.SelectCommand.Parameters.AddWithValue("@schema", Schema.Name);
adapter.SelectCommand.Parameters.AddWithValue("@table", Name);
var dataTable = new TablesDataSet.ColumnDataTable();
adapter.Fill(dataTable);
return(dataTable.Rows.Cast <TablesDataSet.ColumnRow>().Select(r => new Column(r)).ToList());
}
}
private IEnumerable<Column> LoadColumns()
{
using (var adapter = new SqlDataAdapter("select COLUMN_NAME, DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_SCHEMA = @schema and TABLE_NAME = @table order by ORDINAL_POSITION", Schema.Connection.ConnectionString))
{
adapter.SelectCommand.Parameters.AddWithValue("@schema", Schema.Name);
adapter.SelectCommand.Parameters.AddWithValue("@table", Name);
var dataTable = new TablesDataSet.ColumnDataTable();
adapter.Fill(dataTable);
return dataTable.Rows.Cast<TablesDataSet.ColumnRow>().Select(r => new Column(r)).ToList();
}
}
