Level column length

[cremor]

Please clearly describe what the SQL Sink is doing incorrectly:

If I use the "autoCreateSqlDatabase": true setting, the [Level] column is created as NVARCHAR (MAX), although the readme says it's nvarchar(128) here and here.

Please clearly describe the expected behavior:

The auto created table should match the readme.

List the names and versions of all Serilog packages used in the project:

• Serilog: 3.1.1
• Serilog.AspNetCore: 8.0.1
• Serilog.Extensions.Hosting: 8.0.0
• Serilog.Settings.Configuration: 8.0.0
• Serilog.Sinks.Async: 1.5.0
• Serilog.Sinks.Console: 5.0.1
• Serilog.Sinks.Debug: 2.0.0
• Serilog.Sinks.File: 5.0.0
• Serilog.Sinks.MSSqlServer: 6.6.1

Target framework and operating system:

.NET 8 OS: Windows 10

Provide a simple reproduction of your Serilog configuration code:

builder.Host.UseSerilog((context, services, loggerConfiguration) => loggerConfiguration.ReadFrom.Configuration(context.Configuration));

Provide a simple reproduction of your Serilog configuration file, if any:

"Serilog": {
  "Using": [ "Common" ],
  "MinimumLevel": {
    "Default": "Information",
    "Override": {
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "WriteTo": {
    "DbSink": {
      "Name": "MSSqlServer",
      "Args": {
        "connectionString": "DefaultConnection",
        "sinkOptionsSection": {
          "tableName": "Logs",
          "autoCreateSqlTable": true
        }
      }
    }
  }
}

Provide a simple reproduction of your application code:

Just start the app to let the log table creation happen.