public void Can_read_table_with_decimal_column()
{
var table = new DataTable();
table.Columns.Add("Decimal Column");
DataRow row1 = table.NewRow();
DataRow row2 = table.NewRow();
row1["Decimal Column"] = "2.1";
row2["Decimal Column"] = "3.1";
table.Rows.Add(row1);
table.Rows.Add(row2);
IDataTableReader tableReader = new DataTableReader();
tableReader.Open(table);
Assert.That(tableReader.Read(), Is.EqualTo(true));
Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(2.1M));
Assert.That(tableReader.Read(), Is.EqualTo(true));
Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(3.1M));
Assert.That(tableReader.Read(), Is.EqualTo(false));
}
public void Can_read_table_with_decimal_column()
{
var table = new DataTable();
table.Columns.Add("Decimal Column");
DataRow row1 = table.NewRow();
DataRow row2 = table.NewRow();
row1["Decimal Column"] = "2.1";
row2["Decimal Column"] = "3.1";
table.Rows.Add(row1);
table.Rows.Add(row2);
IDataTableReader tableReader = new DataTableReader();
tableReader.Open(table);
Assert.That(tableReader.Read(), Is.EqualTo(true));
Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(2.1M));
Assert.That(tableReader.Read(), Is.EqualTo(true));
Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(3.1M));
Assert.That(tableReader.Read(), Is.EqualTo(false));
}
public void Returns_null_for_an_empty_string_value()
{
var table = new DataTable();
table.Columns.Add("String Column");
table.Columns.Add("Decimal Column");
DataRow row1 = table.NewRow();
row1["String Column"] = string.Empty;
row1["Decimal Column"] = 5.5M;
table.Rows.Add(row1);
IDataTableReader tableReader = new DataTableReader();
tableReader.Open(table);
Assert.That(tableReader.Read(), Is.EqualTo(true));
Assert.That(tableReader.GetString("String Column"), Is.Null);
Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(5.5M));
Assert.That(tableReader.Read(), Is.EqualTo(false));
}
public void Returns_null_for_an_empty_string_value()
{
var table = new DataTable();
table.Columns.Add("String Column");
table.Columns.Add("Decimal Column");
DataRow row1 = table.NewRow();
row1["String Column"] = string.Empty;
row1["Decimal Column"] = 5.5M;
table.Rows.Add(row1);
IDataTableReader tableReader = new DataTableReader();
tableReader.Open(table);
Assert.That(tableReader.Read(), Is.EqualTo(true));
Assert.That(tableReader.GetString("String Column"), Is.Null);
Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(5.5M));
Assert.That(tableReader.Read(), Is.EqualTo(false));
}