EF Core 日志跟踪sql语句

最新推荐文章于 2025-05-14 11:55:06 发布

weixin_30871293

最新推荐文章于 2025-05-14 11:55:06 发布

阅读量507

点赞数 1

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/Justsoso-WYH/p/9560577.html

本文介绍了EF Core日志跟踪SQL语句的方法。首先给出官方文档链接，接着阐述具体步骤，包括新增自定义ILoggerProvider实现类、新增自定义日志处理接口ILogger的实现，还说明了配置DbContext日志记录的两种方式，最后给出转载链接。

EF Core 日志跟踪sql语句

官方文档链接:https://docs.microsoft.com/en-us/ef/core/miscellaneous/logging

1.新增自定义ILoggerProvider实现类

    public class EFLoggerProvider : ILoggerProvider
    {
        public ILogger CreateLogger(string categoryName) => new EFLogger(categoryName);
        public void Dispose() { }
    }

2.新增自定义日志处理接口ILogger的实现

    public class EFLogger : ILogger
    {
        private readonly string categoryName;

        public EFLogger(string categoryName) => this.categoryName = categoryName;

        public bool IsEnabled(LogLevel logLevel) => true;

        public void Log<TState>(LogLevel logLevel, EventId eventId, TState state, Exception exception, Func<TState, Exception, string> formatter) {
            //ef core执行数据库查询时的categoryName为Microsoft.EntityFrameworkCore.Database.Command,日志级别为Information
            if (categoryName == "Microsoft.EntityFrameworkCore.Database.Command"
                    && logLevel == LogLevel.Information) {
                var logContent = formatter(state, exception);
                //TODO: 拿到日志内容想怎么玩就怎么玩吧
                Console.WriteLine();
                Console.ForegroundColor = ConsoleColor.Green;
                Console.WriteLine(logContent);
                Console.ResetColor();
            }
        }

        public IDisposable BeginScope<TState>(TState state) => null;
    }

3.配置DbContext的日志记录

方式一,在DbContext的OnConfiguration中配置

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
            var loggerFactory = new LoggerFactory();
            loggerFactory.AddProvider(new EFLoggerProvider());
            optionsBuilder.UseLoggerFactory(loggerFactory);
            base.OnConfiguring(optionsBuilder);
        }

方式二(AspNet Core),在Startup的ConfigureService中配置

            services.AddDbContext<YourDbContext>(r => {
                //使用ef core mysql 连接
                var loggerFactory = new LoggerFactory();
                loggerFactory.AddProvider(new EFLoggerProvider());

                r.UseMySQL(Configuration.GetConnectionString("your db connection string"))
                    .UseLoggerFactory(loggerFactory);
            });

运行得到效果如图: