.ReadFrom.Configuration(Configuration) does not load serilog.sinks.mssqlserver (dotnetcore 2.0)

[sabbadino]

serilog.sinks.mssqlserver\5.1.0
\serilog.settings.configuration\2.5.0
\serilog.aspnetcore\2.1.0
\serilog\2.6.0

public void Configure( ...
var logger = new LoggerConfiguration()
.ReadFrom.Configuration(Configuration)
.CreateLogger();

appsettings

"Serilog": {
"MinimumLevel": "Debug",
"WriteTo": [
{
"Name": "RollingFile",
"Args": { "pathFormat": "D:\IS2009\Service\MediaPortal.Events.Api\logs\mediaportal\events-{Date}.txt" }
},
{
"Name": "MSSqlServer",
"Args": {
"ConnectionString": "Data Source=...",
"TableName": "FullLog"
}
}
]
},

"RollingFile" is loaded but "MSSqlServer" is not , what am I doing wrong ?

}

if I do
var logger = new LoggerConfiguration()
.WriteTo.MSSqlServer(connectionString, tableName, columnOptions: columnOptions)
.CreateLogger();

It does work ?!

thank you
enrico

[tsimbalar]

Hi,

the name of the keys of the Args section in the json configuration file are the names of the parameters of the method ... but it is case-sensitive

In this case, the underlying method is :

public static LoggerConfiguration MSSqlServer(
            this LoggerSinkConfiguration loggerConfiguration,
            string connectionString,
            string tableName,
            LogEventLevel restrictedToMinimumLevel = LevelAlias.Minimum,
            int batchPostingLimit = MSSqlServerSink.DefaultBatchPostingLimit,
            TimeSpan? period = null,
            IFormatProvider formatProvider = null,
            bool autoCreateSqlTable = false,
            ColumnOptions columnOptions = null,
            string schemaName = "dbo"
)

so your config file should look like :

... stuff before ...
{
  "Name": "MSSqlServer",
  "Args": {
    "connectionString": "Data Source=...",
    "tableName": "FullLog"
 }
}
... stuff after ...

[sabbadino]

Thank you, that was the problem ..
Wheere can I find a sample about settings columns options by json configuration ?
thank you
Enrico

[tsimbalar]

I believe it is not supported in json configuration at the moment ...

See #109 ; #74

[sabbadino]

thank you .

BTW : it seems I can redefine the name of basic "built in columns" :
var columnOptions = new ColumnOptions();
columnOptions.Id.ColumnName = "FullLogId";

but I find no way to change the data type
is it true ?

thank you
enrico

[MV10]

BTW : it seems I can redefine the name of basic "built in columns" :
var columnOptions = new ColumnOptions();
columnOptions.Id.ColumnName = "FullLogId";
but I find no way to change the data type
is it true ?

Correct. PR123 will let you specify column options as long as you're using .NET Standard's Microsoft.Extensions.Configuration.