Example #1
0
        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");
            }
        }