Program.cs

public static void Main(string[] args)
{
   ...
   
  Log.Logger = new LoggerConfiguration()
        .Enrich.FromLogContext()
        .WriteTo.MSSqlServer(
            connectionString: appSettings.GetConnectionString("DB"),
            sinkOptions: sinkOpts,
            columnOptions: columnOptions,
            restrictedToMinimumLevel: LogEventLevel.Error
        ).CreateLogger();
}