Unable to add LogType to ColumnOptions.Store from config appSettings

[kanthikp]

Currenlty there is no way to add/remove the Standard Columns from ColumnOption.Store using the config appSettings.
example settings as below:

<add key="serilog:using:MSSqlServer" value="Serilog.Sinks.MSSqlServer"     />
    <add key="serilog:write-to:MSSqlServer" />
    <add key="serilog:write-to:MSSqlServer.connectionString" value="conncetionstring" />
    <add key="serilog:write-to:MSSqlServer.tableName" value="ApplicationSerilog" />
    <add key="serilog:write-to:MSSqlServer.autoCreateSqlTable" value="true" />
    **<add key="serilog:write-to:MSSqlServer.columnOptions.Store" value="[0,1,2,3,4,5,6]" />**

Is there any workaround?

[JamesItSolutionsLtd]

I also require this. Does anyone have a solution

[alphaleonis]

Seems to be a duplicate of #103, or close to it anyway. No such support exists as of now from what I understand (or can find in the codebase), but it should be possible to extend the MSSqlServerConfigurationSection and add support for this.

[MV10]

Part of a PR I'm working on should prepare app.config for another PR to bring it up to full parity with JSON config.

[MV10]

Actively working on the XML config PR now.

I had forgotten what a giant hassle XML configuration is! 😀

[MV10]

The PR will be open for a few days and I have more testing to do, but the updated External Configuration section of the revised docs shows that all features can be configured from XML after this change:

https://github.com/serilog/serilog-sinks-mssqlserver/blob/9574ce3b1f30d7ea7fe813fe492bcff38ddcb353/README.md#xml-net-framework-columnoptions-configuration