ASP.NET Core 1.1 log all DbContext queries to output window

Question

How can I log all queries to output when using DbContext?

In the past I get all queries (SQLs) in Output window in Visual studio 2015. I don't know when this has stopped.

public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, DbSeeder dbSeeder)
{
    loggerFactory.AddConsole(Configuration.GetSection("Logging"));
    loggerFactory.AddDebug();

And appsettings.json:

  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Microsoft": "Information"
    }

This is not working. And I think this means the logs should be in output.

Edited:

I think it is not possible without some work around. GitHub1, GitHub2.

For now I went with SQL Server Profiler.

score 0 · Answer 1 · answered Feb 22 '17 at 09:11

0

Set the Microsoft LogLevel in appsettings.json to Debug or Verbose. The default LogLevel is only used if there isn't a more specific level, and Entity Framework looks at the Microsoft level.

AddConsole is what makes the affected logs get printed to stdout according to the Logging section you pass in.

answered Feb 22 '17 at 09:11

Jesper

7,477
4
40
57

It is not working. For Verbose it returns error: Additional information: Configuration value 'Verbose' for category 'Microsoft' is not supported. – Makla Feb 22 '17 at 09:36
And when you try "Debug"? – Jesper Feb 22 '17 at 15:04
Try "Trace", they renamed the logging levels. – Jesper Feb 22 '17 at 15:06
Setting Logging:LogLevel:Microsoft to Trace does not help. – Makla Feb 22 '17 at 15:16

ASP.NET Core 1.1 log all DbContext queries to output window

1 Answers1