Disable Entity Framework logging in Azure Function

Question

I have an Azure Function in .net5 (a.k.a. dotnet-isolated) and I've added Entity Framework like this

services.AddDbContext<EfDbContext>(options =>
{
    options.UseSqlServer(context.Configuration[...], builder =>
    {
        builder.EnableRetryOnFailure();
    });
});

When I run the function I see the DB queries from EF in the console (info level judging by the color).

How can I disable them? I tried obvious options in my host.json:

"logging": {
    "logLevel": {
        "Microsoft.EntityFrameworkCore": "Warning",
    }
}

and

"logging": {
    "logLevel": {
        "default": "Information",
        "Microsoft.EntityFrameworkCore": "Warning",
        "Microsoft.EntityFrameworkCore.Database": "Warning",
        "Microsoft.EntityFrameworkCore.Query": "Warning"
    }
}

or even

"logging": {
    "logLevel": {
        "Microsoft": "Warning",
    }
}

but it didn't help. The only option which worked was

"logging": {
    "logLevel": {
        "default": "Warning",
    }
}

Am I missing something?

Could it be that you have custom logging? I would try to search for 'Executed DbCommand' in the project — Vova Bilyachat
– Vova Bilyachat, Commented May 13, 2021 at 11:49

Andrey Stukalin · Accepted Answer · 2021-05-17 06:45:06Z

18

Found a way. That's a bit strange though and I still wanna understand how it works and why it's done this way. Anyways, from AppInsights logs I found out that EF logs are written under the Function.<YOUR_FUNCTION_NAME>.User category. (turns out that a standard EF category is somehow overwritten by the functions runtime or so?).

That means that I can impact on the overall log level of a specific function by

    "logging": {
        "logLevel": {
            "Function.MyFunc1.User": "Debug",
            "Function.MyFunc2.User": "Warning"
        }
    }

in the host.json. It can be helpful but it doesn't solve my problem.

If however I now add a filter in the Program.cs like this:

var host = new HostBuilder()
  .ConfigureFunctionsWorkerDefaults()
  ...               
  .ConfigureLogging(builder =>
  {
    builder.AddFilter("Microsoft.EntityFrameworkCore", LogLevel.Warning);
  })
  ...

the EF info logs are gone.

answered May 17, 2021 at 6:45

Andrey Stukalin

6,0042 gold badges36 silver badges56 bronze badges

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

2 Comments

Vladimir Over a year ago

just to possibly save someone`s time you need to reference using Microsoft.Extensions.Logging , my intellisense in VS2022 was not giving me this suggestion only displaying that AddFilter does not exist

fedda Over a year ago

Have you tried,: builder.Logging.AddFilter("Microsoft.EntityFrameworkCore", LogLevel.Warning);

andy · Accepted Answer · 2021-10-07 16:11:16Z

2

This worked for me:

builder.AddFilter("Microsoft.EntityFrameworkCore", LogLevel.None);

answered Oct 7, 2021 at 16:11

andy

211 bronze badge

Collectives™ on Stack Overflow

Disable Entity Framework logging in Azure Function

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related