Enable raw SQL logging in Entity Framework Core

Question

How do I enable the logging of DbCommand raw SQL queries?

I have added the following code to my Startup.cs file, but do not see any log entries from the Entity Framework Core.

void ConfigureServices(IServiceCollection services)
{
    services.AddLogging();
}

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

I'm expecting to see something like this:

Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilder...
SELECT [t].[Id], [t].[DateCreated], [t].[Name], [t].[UserName]
FROM [Trips] AS [t]

Pingolin · Accepted Answer · 2019-02-15 07:16:10Z

6

From MVC Core 2, logging SQL is the default behaviour. Just make sure logging level in appSettings json file is correct.

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

edited Feb 15, 2019 at 7:16

Pingolin

3,4677 gold badges29 silver badges43 bronze badges

answered Feb 15, 2019 at 6:49

Sharon Zhou

611 silver badge4 bronze badges

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

Comments

codersl · Accepted Answer · 2016-09-02 03:33:57Z

4

Figured it out - need to configure DbContext to use logger factory.

protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    base.OnConfiguring(optionsBuilder);

    optionsBuilder.UseLoggerFactory(_loggerFactory);
}

answered Sep 2, 2016 at 3:33

codersl

2,3425 gold badges32 silver badges34 bronze badges

4 Comments

Matt Over a year ago

Just to note to others reading the above code: the _loggerFactory parameter is set using constructor dependency injection in your FooContext class.

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.

meze Over a year ago

If you use asp.net mvc core, no need to do anything, just make sure that the logging verbosity is "info".

Buğra Ekuklu Over a year ago

@meze it does not matter whether you use .NET Core or not, if you're registering your DbContext with services.AddDbContext(...). This method assures that applications standard logging factory is already registered, or it throws an exception if it is not able to find one.

Collectives™ on Stack Overflow

Enable raw SQL logging in Entity Framework Core

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related