public void LogWithConsoleLogger()
{
var loggerFactory = LoggerFactory.Create(builder =>
{
builder
.AddConsole((options) => {})
.AddFilter((category, level) =>
category == DbLoggerCategory.Database.Command.Name &&
level == LogLevel.Information);
});
using (var ordersDbContext = new OrdersDbContext(loggerFactory))
{
var orderLines = ordersDbContext.OrderLines.Where(o => o.Id == Guid.Empty).ToList();
orderLines = ordersDbContext.OrderLines.ToList();
}
}
public void LogWithCustomLogger()
{
var entityFrameworkSqlLogger = new EntityFrameworkSqlLogger((m) =>
{
Console.WriteLine($"SQL Query:\r\n{m.CommandText}\r\nElapsed:{m.Elapsed} millisecods\r\n\r\n");
});
var loggerFactory = LoggerFactory.Create(builder =>
{
builder
.AddFilter((category, level) =>
category == DbLoggerCategory.Database.Command.Name &&
level == LogLevel.Information);
});
loggerFactory.AddProvider(new SingletonLoggerProvider(entityFrameworkSqlLogger));
using (var ordersDbContext = new OrdersDbContext(loggerFactory))
{
var orderLines = ordersDbContext.OrderLines.Where(o => o.Id == Guid.Empty).ToList();
orderLines = ordersDbContext.OrderLines.ToList();
}
}
