使用最新的.Net Core(3.0预览版)和EF Core(3.0预览版)查看一些在线资源,我这样做:
using latest .Net Core (3.0 preview) and EF Core (3.0 preview) looking at a few online sources I did this:
Program.cs
public class MainWorker : IHostedService { public static readonly ILoggerFactory ConsoleLoggerFactory = LoggerFactory.Create(builder => builder.AddConsole();MyDbContext.cs
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { string connectionString = ... optionsBuilder .UseLoggerFactory(MainWorker.ConsoleLoggerFactory) .EnableSensitiveDataLogging(true) .UseSqlite(connectionString); }所有这些都构建并运行良好,但是当使用EF查询数据库而不是仅 的实际SQL查询时,看到的条目如下:
This all builds and runs fine but when using EF to query my DB instead of the actual SQL queries I only see are entries such as:
信息:Microsoft.EntityFrameworkCore.Infrastructure [10403]实体框架核心3.0.0-preview4.19176.6使用提供程序初始化了"MyDbContext"带有选项的"Microsoft.EntityFrameworkCore.Sqlite":SensitiveDataLoggingEnabled
info: Microsoft.EntityFrameworkCore.Infrastructure[10403] Entity Framework Core 3.0.0-preview4.19176.6 initialized 'MyDbContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite' with options: SensitiveDataLoggingEnabled
如何获取IQueryable的实际SQL查询?
How can I get the actual SQL query for an IQueryable ?
有帮助吗?
推荐答案更新:根据提供的反馈,以下更改为已恢复在3.0预览版7中.
Update: Based on the provided feedback, the below change has been reverted in 3.0 preview 7.
这是预期的重大更改-查询执行记录在调试级.
该链接说明了为什么原因以及如何使用 DbContextOptionsBuilder 恢复在 Info 级别(默认)记录SQL的先前行为:
The link explains why is that and how to get back the previous behavior of logging SQL at Info level (the default) using the DbContextOptionsBuilder:
.ConfigureWarnings(c => c.Log((RelationalEventId.CommandExecuting, LogLevel.Info)));另一种方法是使用 AddFilter 方法将 DbLoggerCategory.Database.Command 类别的最低日志级别更改为 Debug > ILoggingBuilder :
Another way is to change the minimum log level for DbLoggerCategory.Database.Command category to Debug using the AddFilter method of the ILoggingBuilder:
.AddFilter(DbLoggerCategory.Database.Command.Name, LogLevel.Debug)更多推荐
适用于SQLite的.NET Core 3.0 ConsoleLoggerFactory
发布评论