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)); }