public void TestGetDataReaderFromSql()
{
const string sql = "SELECT * FROM dbo.Customer";
var erg = _db.GetDataReader(sql);
Assert.IsTrue(erg.FieldCount > 0);
}
/// <summary>
/// Get all rows in table Customer
/// </summary>
public IList <Customer> GetAll()
{
var result = new List <Customer>();
var reader = _db.GetDataReader("SELECT * FROM \"Customer\"");
while (reader.Read())
{
var dto = DataHelper.MapFromDbToCustomer(reader);
result.Add(dto);
}
reader.Dispose();
return(result);
}