public void Execute_Normally_AllHappens()
{
var testable = new SqlDatabaseSession(_sqlContext.Object, _logger);
testable.Execute("DELETE FROM Cable WHERE Id = @id", new { id = 12 });
testable.ExecutionTime.Should().Be(new TimeSpan(0, 0, 0, 0, 386)); // Gets passed from internal dependency.
_sqlContext.Verify(m => m.ExecuteSql(It.IsAny <Func <IDbTransaction, int> >()), Times.Once);
_logger.LoggedMessages.Should().HaveCount(1);
_logger.LoggedMessages[0].Should().Be("TRACE: Execute(DELETE FROM Cable WHERE Id = @id) issued for SqlDatabaseSession.");
}
public void Execute_Typed_AllHappens()
{
var testable = new SqlDatabaseSession(_sqlContext.Object, _logger);
string result = testable.Execute <string>("SELECT label FROM Somewhere WHERE Id = @id", new { id = 12 });
testable.ExecutionTime.Should().Be(new TimeSpan(0, 0, 0, 0, 386)); // Gets passed from internal dependency.
_sqlContext.Verify(m => m.ExecuteSql(It.IsAny <Func <IDbTransaction, object> >()), Times.Once);
_logger.LoggedMessages.Should().HaveCount(1);
_logger.LoggedMessages[0]
.Should()
.Be("TRACE: Execute<T>(SELECT label FROM Somewhere WHERE Id = @id) called with expected return of type String.");
}