title: Configure custom Column Options for Serilog Sinks MsSqlServer in AppSettings.json is not working
body: <p>I'm trying to determine if it's possible to configure the column options for serilog sink mssqlserver in the <code>appsettings.json</code> file for an ASP.Net Core 3 project.</p>
  
  <p>besides not filling the custom columns, the database is also created in the standard way without these column, so I added them by hand. This could point to a configuration issue? </p>
  
  <p>The SQL to create the table</p>
  
  <pre><code>    CREATE TABLE [dbo].[logtable](
          [Id] [int] IDENTITY(1,1) NOT NULL,
          [Message] [nvarchar](max) NULL,
          [MessageTemplate] [nvarchar](max) NULL,
          [Level] [nvarchar](128) NULL,
          [TimeStamp] [datetimeoffset](7) NOT NULL,
          [Exception] [nvarchar](max) NULL,
          [Properties] [xml] NULL,
          [LogEvent] [nvarchar](max) NULL,
          [Controller_Name] [varchar](500) NULL,
          [Method_Name] [varchar](500) NULL,
          [StackTrace] [varchar](500) NULL
      )
  </code></pre>
  
  <p>I create and configure the logger in the <code>Program.cs</code> file.</p>
  
  <pre><code>
      public static IWebHost BuildWebHost(string[] args) =&gt;
                  WebHost.CreateDefaultBuilder(args)
                      .UseStartup&lt;Startup&gt;()
                      .UseSerilog()
                      .Build();
  
      Log.Logger = new LoggerConfiguration()
                          .ReadFrom.Configuration(configuration)
                          .CreateLogger();
  
  </code></pre>
  
  <p>I can build the configuration file from the <code>appsettings.json</code> file, which contains a Serilog node with information for which connection string and table to use.</p>
  
  <pre><code>"Serilog": {
      "Using": [ "Serilog.Sinks.MSSqlServer" ],
      "MinimumLevel": "Information",
      "WriteTo": [
        {
          "Name": "MSSqlServer",
          "Args": {
            "connectionString": "Data Source=SWPC159; Initial Catalog=master;Trusted_Connection=True;", // connection String
            "tableName": "logtable",
            "columnOptionsSection": {
              "disableTriggers": true,
              "clusteredColumnstoreIndex": false,
              "addStandardColumns": [ "LogEvent" ],
              "removeStandardColumns": [ "MessageTemplate", "Properties" ],
              "additionalColumns": [
                {
                  "ColumnName": "Controller_Name",
                  "DataType": "varchar",
                  "AllowNull": true,
                  "DataLength": 500
                },
                {
                  "ColumnName": "Method_Name",
                  "DataType": "varchar",
                  "AllowNull": true,
                  "DataLength": 500
                },
                {
                  "ColumnName": "StackTrace",
                  "DataType": "varchar",
                  "AllowNull": true,
                  "DataLength": 500
                }
              ]
            }
          }
        }
      ]
    }
  </code></pre>