public void DataTableFromEnumerableTest_nullable()
{
var records = new[]
{
new ItemT {Name = "Foo", NullableAge = null},
new ItemT {Name = "Bar", NullableAge = 1}
};
var items = from i in records
select new {i.Name, i.NullableAge};
var datatable = Isotope.Data.DataTableBuilder.FromEnumerable(items);
Assert.AreEqual(2, datatable.Rows.Count);
Assert.AreEqual(2, datatable.Columns.Count);
Assert.AreEqual("Name", datatable.Columns[0].ColumnName);
Assert.AreEqual("Name", datatable.Columns[0].Caption);
Assert.AreEqual(typeof (string), datatable.Columns[0].DataType);
Assert.AreEqual("NullableAge", datatable.Columns[1].ColumnName);
Assert.AreEqual("NullableAge", datatable.Columns[1].Caption);
Assert.AreEqual(typeof (int), datatable.Columns[1].DataType);
Assert.AreEqual("Foo", datatable.Rows[0][0]);
Assert.IsTrue(datatable.Rows[0][1] is System.DBNull);
Assert.AreEqual("Bar", datatable.Rows[1][0]);
Assert.AreEqual(1, datatable.Rows[1][1]);
}
public void DataTableFromEnumerableTest_struct()
{
var records = new[]
{
new S1{Name = "Foo"},
new S1{Name = "Bar"}
};
var datatable = Isotope.Data.DataTableUtil.DataTableFromEnumerable(records);
Assert.AreEqual(2, datatable.Rows.Count);
Assert.AreEqual(1, datatable.Columns.Count);
Assert.AreEqual("Name", datatable.Columns[0].ColumnName);
Assert.AreEqual("Name", datatable.Columns[0].Caption);
Assert.AreEqual(typeof(string), datatable.Columns[0].DataType);
Assert.AreEqual("Foo", datatable.Rows[0][0]);
Assert.AreEqual("Bar", datatable.Rows[1][0]);
}
