using Microsoft.Extensions.Logging; using System; namespace DBHelper { public class EfLoggerProvider : ILoggerProvider { public ILogger CreateLogger(string categoryName) => new EfLogger(categoryName); public void Dispose() { } } public class EfLogger : ILogger { private readonly string _categoryName; public EfLogger(string categoryName) => this._categoryName = categoryName; public bool IsEnabled(LogLevel logLevel) => true; public void Log(LogLevel logLevel, EventId eventId, TState state, Exception exception, Func formatter) { //ef core执行数据库查询时的categoryName为Microsoft.EntityFrameworkCore.Database.Command,日志级别为Information if (_categoryName != "Microsoft.EntityFrameworkCore.Database.Command" || logLevel != LogLevel.Information) return; var logContent = formatter(state, exception); //TODO: 拿到日志内容想怎么玩就怎么玩吧 //Console.WriteLine(); //Console.ForegroundColor = ConsoleColor.Green; //Console.WriteLine(logContent); //Console.ResetColor(); } public IDisposable BeginScope(TState state) => null; } }