efCore3.1+mysql 启用日志查询记录

    技术2022-07-10  128

     1.  Nuget安装 Microsoft.Extensions.Logging

    2.      

     /// <summary>         /// 记录sql语句日志         /// </summary>         public static readonly ILoggerFactory MyLoggerFactory           = LoggerFactory.Create(builder => {          builder.AddFilter((category, level) =>              category == DbLoggerCategory.Database.Command.Name              && level == LogLevel.Information).AddConsole();                    });  //添加日志             services.AddDbContext<SlaughterContext>(options=>options.UseLoggerFactory(MyLoggerFactory).UseMySql(Configuration.GetConnectionString("conStr")));

     

    Processed: 0.011, SQL: 9