Serilog exclude database query log

Question

I used to hide my SQL database logs from Console/Debug by adding this line of code in the Program.cs:

builder.Host.UseSerilog((builderContext, config) =>
{
    config.ReadFrom.Configuration(builderContext.Configuration);
    config.Filter.ByExcluding(Matching.FromSource("Microsoft.EntityFrameworkCore.Database.Command"));
});

How to hide my SQL queries using the appsettings.json file?

"Serilog": {
    "MinimumLevel": {
        "Default": "Information"
    },
    "WriteTo": [
        {
            "Name": "Console",
            "Args": { "outputTemplate": "[{Timestamp:dd/MM/yyyy HH:mm:ss ffff zzz} {Level:u3}] {Message:lj}{NewLine}{Exception}" }
        },
        {
            "Name": "Debug",
            "Args": { "outputTemplate": "[{Timestamp:dd/MM/yyyy HH:mm:ss ffff zzz} {Level:u3}] {Message:lj}{NewLine}{Exception}" }
        },
    ],
    // Tried this but it does not work.
    "Filter": [
        {
            "Name": "ByExcluding",
            "Args": {
                "expression": "SourceContext = 'Microsoft.EntityFrameworkCore.Database.Command'"
            }
        }
    ],
    "Enrich": [
        "FromLogContext"
    ]
},

Mihai Socaciu · Accepted Answer · 2025-03-20 14:36:46Z

0

I found a way by using the available Serilog options, even though its not the same, it does the hiding:

"Serilog": {
    "MinimumLevel": {
        "Default": "Information",
        "Override": {
            "Microsoft.EntityFrameworkCore.Database.Command": "Error"
        }
    },
...

Keeping the question open for a little in case someone knows a better variant.

answered Mar 20 at 14:36

Mihai Socaciu

8122 gold badges9 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Serilog exclude database query log

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related