public void ReadData()
{
using (var connection = new SqlConnection(Northwind))
{
connection.Open();
var dr = new DatabaseSchemaReader.DatabaseReader(connection);
var table = dr.Table("Categories");
var reader = new DatabaseSchemaReader.Data.Reader(table);
var dt = reader.Read(connection);
Assert.IsTrue(dt.Rows.Count > 0);
}
}
public void ReadDataWithFunc()
{
using (var connection = new SqlConnection(Northwind))
{
connection.Open();
var dr = new DatabaseSchemaReader.DatabaseReader(connection);
var table = dr.Table("Categories");
var reader = new DatabaseSchemaReader.Data.Reader(table);
var names = new List <string>();
reader.Read(connection, dataRecord =>
{
var name = dataRecord["CategoryName"].ToString();
names.Add(name);
return(true);
});
Assert.IsTrue(names.Count > 0);
}
}
