Change Logging Level of "Executed DBCommand" for EF Core in Azure Function

Question

Using Azure Function and Log Stream I'm flooded by these types of logs at the "Information" log level:

2023-08-17T21:00:44Z   [Information]   Executed DbCommand (2ms)....

How can I change the log level for the executed DbCommand to log under Trace instead of Information so I'm not flooded w/ these log entries?

I've added the following Configuration -> Application Settings in Azure however I'm still seeing the log entries as Information:

Name: AzureFunctionsJobHost__logging__logLevel__Microsoft
Value: Trace

score 1 · Accepted Answer · answered Aug 17 '23 at 21:51

1

You can use ConfigureWarnings on the context options builder and set the level in Log(ValueTuple<EventId,LogLevel>[]):

services.AddDbContext<AppContext>(builder =>
  builder.Use...(...)
    .LogTo(Console.WriteLine, LogLevel.Information)
    .ConfigureWarnings(b => b.Log((RelationalEventId.CommandExecuted, LogLevel.Trace)))
);

Alternatively you can just use Ignore to completely disable the event.

answered Aug 17 '23 at 21:51

Guru Stron

102,774
10
95
132

is there any way to do this directly from my configuration settings instead? – 99823 Aug 18 '23 at 14:24
@99823 not that I know of. Usually context is not set up directly via config. – Guru Stron Aug 18 '23 at 14:38

Change Logging Level of "Executed DBCommand" for EF Core in Azure Function

1 Answers1

Linked