.net core添加SQL日志输出

GreDbContext : Microsoft.EntityFrameworkCore.DbContext

下添加

  public static readonly ILoggerFactory MyLoggerFactory

        = LoggerFactory.Create(builder => { builder.AddConsole(); });

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            if (!string.IsNullOrEmpty(_conn))

            {

                optionsBuilder.UseMySql(_conn);

                optionsBuilder.EnableSensitiveDataLogging(true);

            }

            optionsBuilder.UseLoggerFactory(MyLoggerFactory); //添加这个

            optionsBuilder.EnableSensitiveDataLogging(); ///这个

            base.OnConfiguring(optionsBuilder);

        }