我使用nlog,并采用以下设置记录SQL查询:
<logger name="Microsoft.EntityFrameworkCore.*"
minlevel="Trace" writeTo="sqllogfile" final="true" />
它按预期工作,但不记录参数值,查询看起来像这样:
2017-07-31 13:49:03.8836| INFO |Microsoft.EntityFrameworkCore.Internal.InterceptingLogger`1.Log|Executed DbCommand (8ms) [Parameters=[@__get_Item_0='?' (Size = 450)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [e].[Id], [e].[AccessFailedCount], [e].[ConcurrencyStamp], [e].[Email], [e].[EmailConfirmed], [e].[HeliosLoginId], [e].[LockoutEnabled], [e].[LockoutEnd], [e].[Name], [e].[NormalizedEmail], [e].[NormalizedUserName], [e].[PasswordHash], [e].[PhoneNumber], [e].[PhoneNumberConfirmed], [e].[SecurityStamp], [e].[TwoFactorEnabled], [e].[UserName]
FROM [AspNetUsers] AS [e]
WHERE [e].[Id] = @__get_Item_0
是否可以显示@__get_Item_0
参数的值?
谢谢
DbContextOptionsBuilder
上调用EnableSensitiveDataLogging
方法。因为值可能包含敏感数据,所以 EF Core 默认不记录值。 - Smit