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); }