Configuring Serilog

Question

User-1204637165 posted

So i have a troubling issue. Which is quite simple but I just not getting it.

 I am trying to configure serilog in such a way that it would not log normal sql statements and it would also log with date and time.

I have my configuration done like this.

public class Startup{

public void Configure(IApplicationBuilder app,ILoggerFactory loggerFactory){


   //Facilitate logging here
   loggerFactory.AddFile("Logs/mylog-{Date}.txt");

   ILogger logger= loggerFactory.CreateLogger<Startup>();
}

//..................
}

Please how do I make this stop logging sql queries. and log with time and date.

Answer 1

User711641945 posted

Hi InspiredJide,

You could use `MinimumLevel.Override`:

public class Program
{
    public static void Main(string[] args)
    {
        Log.Logger = new LoggerConfiguration()
            .MinimumLevel.Information()
            .MinimumLevel.Override("Microsoft.EntityFrameworkCore.Database.Command", LogEventLevel.Warning)
            .WriteTo.File("log.txt", rollingInterval: RollingInterval.Day)
                .CreateLogger();
        CreateWebHostBuilder(args).Build().Run();
    }

    public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
        WebHost.CreateDefaultBuilder(args)
        .UseSerilog()
            .UseStartup<Startup>();
}

Best Regards,

Rena

Answer 2

User-1204637165 posted

Thanks alot,.

I actually have this in my Program.cs but the big challenge I have is that this method call

  .UseSerilog()
That method is highlighted in red line. I don't know why, been battling with it for days.
throws an error in my Program.cs file please look at my import in  Program.cs class below

using Serilog;
using Serilog.Events;
using Seriilog.Configuration;

Please can you help me with hint on what can cause this.

Answer 3

User711641945 posted

Hi InspiredJide,

You need install `Serilog.AspNetCore` package:

https://www.nuget.org/packages/Serilog.AspNetCore/3.0.0

Best Regards,

Rena

Answer 4

User-1204637165 posted

Thanks Boss. I would do this and get back to you.