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