public void ReturnTable()
        {
            var sut = new FakeCommand();

            sut.Setup(new ScalarCommandResult()
            {
                Result = "Hello"
            });
            sut.Setup(new NonQueryCommandResult()
            {
                Result = 0
            });

            sut.CommandText = "SELECT 2";
            var result = sut.ExecuteScalar();

            sut.CommandText = "UPDATE XXXX SET UserId = @userId";
            sut.AddParameter("userId", 1);
            var result2 = sut.ExecuteNonQuery();


            Assert.Equal("Hello", result);
            Assert.Equal("UPDATE XXXX SET UserId = @userId", sut.CommandsList[1].CommandText);
            Assert.Equal(1, sut.CommandsList[1].Parameters[0].Value);
        }
        public void ReturnTable()
        {
            var sut = new FakeCommand();
            sut.Setup(new ScalarCommandResult() { Result = "Hello" });
            sut.Setup(new NonQueryCommandResult() { Result = 0 });

            sut.CommandText = "SELECT 2";
            var result = sut.ExecuteScalar();

            sut.CommandText = "UPDATE XXXX SET UserId = @userId";
            sut.AddParameter("userId", 1);
            var result2 = sut.ExecuteNonQuery();


            Assert.Equal("Hello", result);
            Assert.Equal("UPDATE XXXX SET UserId = @userId", sut.CommandsList[1].CommandText);
            Assert.Equal(1, sut.CommandsList[1].Parameters[0].Value);
        }