Entity Framework Core / 7 SQL Logging

Question

Looking at this similar question I need to do the same thing, that is I want the SQL to be copied to my Output, but I need it done for EF Core / 7

I tried adding the LogFactory as is shown in this example

But that did not produce the SQL output either... what am I missing?

Do you have your loggerFactory configured in Startup.cs? — Matt
– Matt, Commented Jan 29, 2017 at 4:28

Community · Accepted Answer · 2017-05-23 12:02:39Z

1

The EF Core 1.1 example you linked to should work, assuming you have the following in your Configure method in your Startup.cs:

public void Configure(
    IApplicationBuilder application, 
    IHostingEnvironment environment, 
    ILoggerFactory loggerFactory) {

        loggerFactory
            .AddConsole(LogLevel.Debug)  // This will output to the console/terminal
            .AddDebug(LogLevel.Debug);   // This will output to Visual Studio Output window

        // Your additional configuration here...
}

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jan 30, 2017 at 4:19

Matt

3,7072 gold badges29 silver badges41 bronze badges

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

2 Comments

JB's Over a year ago

Just for other who came here with the same problem read out this article. As this answer is not very helpful, except @Matt has added only the scaffolded code.

Matt Over a year ago

But it answered his question :(

HashSix · Accepted Answer · 2017-08-17 10:31:26Z

0

You can also install dotnet tools. The repository contains command-line tools for the .NET Core CLI.

Running dotnet watch run, debugs the application as well as showing you any sql queries that are executed.

I am coding with VS code and not 100% sure if it will work in Visual Studio.

answered Aug 17, 2017 at 10:31

HashSix

1052 silver badges9 bronze badges

Collectives™ on Stack Overflow

Entity Framework Core / 7 SQL Logging

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related