INpgsql trace logger

TraceLoggingProvider.cs

public class TraceLoggingProvider : INpgsqlLoggingProvider
{
    public NpgsqlLogger CreateLogger(string name)
    {
        return new TraceLogger();
    }
}

public class TraceLogger : NpgsqlLogger
{
    public override bool IsEnabled(NpgsqlLogLevel level)
    {
        return true;
    }

    public override void Log(NpgsqlLogLevel level, int connectorId, string msg, Exception exception = null)
    {
        var format = $"{connectorId}: {msg}{(exception != null ? " | " + exception.Message : String.Empty)}";

        switch (level)
        {
            case NpgsqlLogLevel.Trace:
            case NpgsqlLogLevel.Debug:
            case NpgsqlLogLevel.Info:
                Trace.TraceInformation(format);
                break;
            case NpgsqlLogLevel.Warn:
                Trace.TraceWarning(format);
                break;
            case NpgsqlLogLevel.Error:
            case NpgsqlLogLevel.Fatal:
                Trace.TraceError(format);
                break;
        }
    }
}

Usage: NpgsqlLogManager.Provider = new TraceLoggingProvider();