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.

Jesper · Accepted Answer · 2017-02-22 09:11:13Z

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, 2017 at 9:11

Jesper

7,6454 gold badges43 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Makla Over a year ago

It is not working. For Verbose it returns error: Additional information: Configuration value 'Verbose' for category 'Microsoft' is not supported.

Jesper Over a year ago

And when you try "Debug"?

Jesper Over a year ago

Try "Trace", they renamed the logging levels.

Makla Over a year ago

Setting Logging:LogLevel:Microsoft to Trace does not help.

Collectives™ on Stack Overflow

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

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related