C# (CSharp) ResultSetRowCollection.EqualRowCollections Examples

Example #1

File: RowCollectionEqualityComparerTests.cs Project: josibb/sqlunittesting

        public void CanEquateRowValues()
        {
            var rows1 = new ResultSetRowCollection();
            var rows2 = new ResultSetRowCollection();

            Assert.IsTrue(rows1.EqualRowCollections(rows2));

            rows1.Add(new ResultSetRow());
            rows2.Add(new ResultSetRow());
            Assert.IsTrue(rows1.EqualRowCollections(rows2));

            rows1[0]["cola"] = 99;
            Assert.IsFalse(rows1.EqualRowCollections(rows2));
            rows2[0]["cola"] = 99;
            Assert.IsTrue(rows1.EqualRowCollections(rows2));

            rows1.Add(new ResultSetRow());
            rows2.Add(new ResultSetRow());
            Assert.IsTrue(rows1.EqualRowCollections(rows2));

            rows1[1]["abc"] = "hi";
            Assert.IsFalse(rows1.EqualRowCollections(rows2));
            rows2[1]["abc"] = "hi";
            Assert.IsTrue(rows1.EqualRowCollections(rows2));

            rows1.Add(new ResultSetRow());
            rows2.Add(new ResultSetRow());
            rows1[1]["test"]  = "klm";
            rows2[2]["test2"] = "klm";
            Assert.IsFalse(rows1.EqualRowCollections(rows2));
        }