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