public static void LogSql(this ILogger logger, string serverName, string sqlRequest, TimeSpan duration, DateTimeOffset startTime, bool success = true, LogLevel logLevel = LogLevel.Information) { var state = new SqlDependencyState { EventTime = startTime, Request = sqlRequest, ResponseTime = duration, Success = success, ServerName = serverName }; logger.Log(logLevel, 1, state, null, SqlDependencyState.Formatter); }
public static void LogSql(this ILogger logger, string serverName, string sqlRequest, TimeSpan duration, DateTimeOffset startTime, Exception exception, LogLevel logLevel = LogLevel.Error) { var state = new SqlDependencyState { EventTime = startTime, Request = sqlRequest, ResponseTime = duration, Success = false, ServerName = serverName }; logger.Log(logLevel, 1, state, exception, SqlDependencyState.Formatter); }