public void CanReadAllDataProperly() { var builder = new SimpleMockDataReaderBuilder(). SetNullValueHandling(NullValueHandling.AssumeAsDbNull). AddColumn("ID_PRODUCT", typeof(long)). AddColumn("PRODUCT_NAME", typeof(string)). AddColumn("IS_ACTIVE", typeof(bool)). AddColumn("BARCODE", typeof(string)). AddData(1L, "Product 1", true, null); using (var reader = new MockDataReader(builder)) { reader.Read(); reader.IsDBNull(0).ShouldBe <bool>(false); reader.GetInt64(0).ShouldBe <long>(1); reader.GetValue(0).ShouldBe <object>(1); reader["ID_PRODUCT"].ShouldBe <object>(1); reader.IsDBNull(1).ShouldBe <bool>(false); reader.GetString(1).ShouldBe <string>("Product 1"); reader.GetValue(1).ShouldBe <object>("Product 1"); reader["PRODUCT_NAME"].ShouldBe <object>("Product 1"); reader.IsDBNull(2).ShouldBe <bool>(false); reader.GetBoolean(2).ShouldBe <bool>(true); reader.GetValue(2).ShouldBe <object>(true); reader["IS_ACTIVE"].ShouldBe <object>(true); reader.IsDBNull(3).ShouldBe <bool>(true); reader.GetValue(3).ShouldBe <object>(DBNull.Value); reader["BARCODE"].ShouldBe <object>(DBNull.Value); } }
public void CanReadAllDataProperly() { var dataList = new List <TestObjectClass>(); dataList.Add(new TestObjectClass { IntProperty = 10, StringProperty = "ten" }); dataList.Add(new TestObjectClass { IntProperty = 20, StringProperty = "twenty" }); dataList.Add(new TestObjectClass { IntProperty = 30, StringProperty = "thirty" }); var builder = new ObjectBasedMockDataReaderBuilder <TestObjectClass>(). SetNullValueHandling(NullValueHandling.AssumeAsDbNull). AddData(dataList); using (var reader = new MockDataReader(builder)) { reader.Read().ShouldBe <bool>(true); reader.Read().ShouldBe <bool>(true); reader.IsDBNull(0).ShouldBe(false); reader.GetInt32(0).ShouldBe <int>(20); reader.GetValue(0).ShouldBe <object>(20); reader.IsDBNull(1).ShouldBe <bool>(false); reader.GetString(1).ShouldBe <string>("twenty"); reader.GetValue(1).ShouldBe <object>("twenty"); } }