public static ILoggerFactory UseSqlLogger(this ILoggerFactory loggerFactory, Action <SqlLoggerConfiguration> sqlConfiguration)
{
var config = new SqlLoggerConfiguration();
sqlConfiguration(config);
return(AddLogger(loggerFactory, config));
}
public static ILoggerFactory UseSqlLogger(this ILoggerFactory loggerFactory, IConfiguration configuration)
{
var sqlConfiguration = new SqlLoggerConfiguration()
{
LogLevel = Enum.Parse <LogLevel>(configuration["SqlLoggerConfiguration:LogLevel"]),
ConnectionString = configuration["SqlLoggerConfiguration:ConnectionString"]
};
return(AddLogger(loggerFactory, sqlConfiguration));
}
public static ILoggerFactory UseSqlLogger(this ILoggerFactory loggerFactory, LogLevel logLevel, string connectionString)
{
var sqlConfiguration = new SqlLoggerConfiguration()
{
LogLevel = logLevel,
ConnectionString = connectionString
};
return(AddLogger(loggerFactory, sqlConfiguration));
}
private static ILoggerFactory AddLogger(ILoggerFactory loggerFactory, SqlLoggerConfiguration sqlConfiguration)
{
if (string.IsNullOrWhiteSpace(sqlConfiguration.ConnectionString))
{
throw new ArgumentNullException(nameof(sqlConfiguration), $"'{nameof(SqlLoggerConfiguration)}.{nameof(SqlLoggerConfiguration.ConnectionString)}' cannot be null or empty");
}
loggerFactory.AddProvider(new SqlLoggerProvider(sqlConfiguration));
return(loggerFactory);
}
public SqlLoggerProvider(SqlLoggerConfiguration configuration)
{
_configuration = configuration;
}
public static ILoggerFactory UseSqlLogger(this ILoggerFactory loggerFactory, SqlLoggerConfiguration sqlConfiguration)
{
return(AddLogger(loggerFactory, sqlConfiguration));
}
public SqlLogger(string name, SqlLoggerConfiguration configuration)
{
_name = name;
_configuration = configuration;
}
