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