public void GetColumns()
{
IList<SqlColumnInfo> customer_columns;
IList<SqlColumnInfo> order_columns;
using (var reader = new SqlSchemaReader(_cstr_db))
{
customer_columns = reader.GetColumns("dbo.customer");
order_columns = reader.GetColumns("[dbo].[ORDER]");
}
Assert.IsTrue(customer_columns.Any());
Assert.IsTrue(order_columns.Any());
var id_column = customer_columns.SingleOrDefault(c => c.Name == "Id");
Assert.IsNotNull(id_column);
Assert.IsTrue(id_column.Identity);
Assert.IsFalse(id_column.Nullable);
Assert.IsTrue(id_column.ColumnId == 1);
var name_column = customer_columns.SingleOrDefault(c => c.Name == "FirstName");
Assert.IsNotNull(name_column);
Assert.IsFalse(name_column.Identity);
Assert.IsTrue(name_column.Nullable);
Assert.IsTrue(name_column.ColumnId == 3);
}
public void GetColumns()
{
IList <SqlColumnInfo> customer_columns;
IList <SqlColumnInfo> order_columns;
using (var reader = new SqlSchemaReader(_cstr_db))
{
customer_columns = reader.GetColumns("dbo.customer");
order_columns = reader.GetColumns("[dbo].[ORDER]");
}
Assert.IsTrue(customer_columns.Any());
Assert.IsTrue(order_columns.Any());
var id_column = customer_columns.SingleOrDefault(c => c.Name == "Id");
Assert.IsNotNull(id_column);
Assert.IsTrue(id_column.Identity);
Assert.IsFalse(id_column.Nullable);
Assert.IsTrue(id_column.ColumnId == 1);
var name_column = customer_columns.SingleOrDefault(c => c.Name == "FirstName");
Assert.IsNotNull(name_column);
Assert.IsFalse(name_column.Identity);
Assert.IsTrue(name_column.Nullable);
Assert.IsTrue(name_column.ColumnId == 3);
}
