Add logging as in SqlServer provider

[npgsql]

Add logging as in SqlServer provider

[Guillaume-Fortin]

Can you give me a possibility to disable database request in console application without disable console log in Asp.Net CORE application?
I think npgsql request debug information is define as Information trace level and not on debug trace level.
If i define min log level on "Information", i view all request in logger. So, poor performance.
what I did not understand?

[roji]

@Thetyne I don't understand... Are you talking about Npgsql's logging capabilities or about Entity Framework Code? If it's Npgsql then it belongs in the Npgsql repo. Most of Npgsql's logging is done on level debug (except for warnings and errors).

[Guillaume-Fortin]

i define like this:
`
var sqlLoggerFactory = new LoggerFactory();
sqlLoggerFactory.AddConsole(Configuration.GetSection("SqlLogging"));

entityFramework = entityFramework.AddEntityFrameworkNpgsql().AddDbContext(options =>
options.UseNpgsql(WebAppConfiguration.DatabaseConnectionString).UseLoggerFactory(sqlLoggerFactory));`

If i define in appsettings.json:
"SqlLogging": {
"IncludeScopes": false,
"LogLevel": {
"Default": "Information",
"System": "Information",
"Microsoft": "Information"
}
}
I view sql request in logger.

But if i change "Microsoft": "Information" by "Microsoft": "Critical", the trace of sql request disappear.

I think i don't unserstand something about Log level.

[roji]

This is a question specific to Microsoft's logging package and isn't really related to Npgsql.

But looking at your config, everything seems to make sense... Saying "Information" means "Information and above" (so also error, critical..), saying "Critical" means "only critical". So it makes sense for all logging to disappear - that's what you asked for...

[Guillaume-Fortin]

Ok, thanks for this explication

[roji]

AFAIK this is has been done although there may be various missing places, will address those as they come up.