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