public void ExecuteBatchString() { SetupCommandExpectations("ABCDEFG", null, delegate { Expect.Call(_commandMock.ExecuteNonQuery()).Return(5); }); _mockRepository.ReplayAll(); TestableDatabaseAgent agent = new TestableDatabaseAgent(_connectionStub); int result = agent.ExecuteBatchString(_connectionStub, "ABCDEFG", null); _mockRepository.VerifyAll(); Assert.That(result, Is.EqualTo(5)); }
public void ExecuteScalarCommand() { SetupCommandExpectations("my command", null, delegate { Expect.Call(_commandMock.ExecuteScalar()).Return("foo"); }); _mockRepository.ReplayAll(); TestableDatabaseAgent agent = new TestableDatabaseAgent(_connectionStub); object result = agent.ExecuteScalarCommand("my command"); Assert.That(result, Is.EqualTo("foo")); _mockRepository.VerifyAll(); }
public void ExecuteCommand_ReturnsCount() { SetupCommandExpectations("my command", null, delegate { Expect.Call(_commandMock.ExecuteNonQuery()).Return(15); }); _mockRepository.ReplayAll(); TestableDatabaseAgent agent = new TestableDatabaseAgent(_connectionStub); int result = agent.ExecuteCommand("my command"); Assert.That(result, Is.EqualTo(15)); _mockRepository.VerifyAll(); }
public void ExecuteBatchString_EmptyLines() { SetupCommandExpectations("ABC", null, delegate { Expect.Call(_commandMock.ExecuteNonQuery()).Return(10); }); SetupCommandExpectations("GFE", null, delegate { Expect.Call(_commandMock.ExecuteNonQuery()).Return(20); }); _mockRepository.ReplayAll(); TestableDatabaseAgent agent = new TestableDatabaseAgent(_connectionStub); int result = agent.ExecuteBatchString(_connectionStub, "ABC\n\nGO\n\n\nGFE\n\n", null); _mockRepository.VerifyAll(); Assert.That(result, Is.EqualTo(30)); }