public void CanEquateResultSets()
        {
            var rs1 = new ResultSet();
            var rs2 = new ResultSet();

            Assert.IsTrue(rs1.EqualResultSet(rs2));

            // schema check?
            rs1.Schema.Columns.Add(new Column {
                Name = "cola", ClrType = typeof(int), DbType = "nvarchar"
            });
            Assert.IsFalse(rs1.EqualResultSet(rs2));
            rs2.Schema.Columns.Add(new Column {
                Name = "cola", ClrType = typeof(int), DbType = "nvarchar"
            });
            Assert.IsTrue(rs1.EqualResultSet(rs2));

            // rows check
            rs1.Rows.Add(new ResultSetRow());
            Assert.IsFalse(rs1.EqualResultSet(rs2));
            rs2.Rows.Add(new ResultSetRow());
            Assert.IsTrue(rs1.EqualResultSet(rs2));

            rs1.Rows[0]["cola"] = "hey";
            Assert.IsFalse(rs1.EqualResultSet(rs2));
            rs2.Rows[0]["cola"] = "abc";
            Assert.IsFalse(rs1.EqualResultSet(rs2));
            rs2.Rows[0]["cola"] = "hey";
            Assert.IsTrue(rs1.EqualResultSet(rs2));
        }