serilog-sinks-mssqlserver icon indicating copy to clipboard operation
serilog-sinks-mssqlserver copied to clipboard

TimeStamp column nullable or not

Open cremor opened this issue 1 year ago • 0 comments

Please clearly describe what the SQL Sink is doing incorrectly:

If I use the "autoCreateSqlDatabase": true setting, the [TimeStamp] column is created as NULL, although the readme says it's NOT NULL 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.

cremor avatar Jun 11 '24 13:06 cremor