1. 使用 Nuget 引入如下两个包:
Microsoft.Extensions.Logging
Microsoft.Extensions.Logging.Console
2. 在 DbContext.cs 中加入以下代码
public static readonly LoggerFactory LoggerFactory = new LoggerFactory(new[] { new DebugLoggerProvider() }); protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); optionsBuilder.UseLoggerFactory(LoggerFactory).UseMySql("server=xxx.xxx.xx.x;uid=xxx;pwd=...;database=xxx", x => x.ServerVersion("5.7.26-mysql")); optionsBuilder.EnableSensitiveDataLogging(); optionsBuilder.EnableDetailedErrors(); optionsBuilder.ConfigureWarnings( b => b.Log( (RelationalEventId.ConnectionOpened, LogLevel.Information), (RelationalEventId.ConnectionClosed, LogLevel.Information))); }
3. 运行后在输出中可以看到SQL语句
标签:语句,Core,EF,xxx,optionsBuilder,SQL,new,LoggerFactory From: https://www.cnblogs.com/maruko/p/18061491