appSettings not read, Unable to find a method called MSSqlServer

[Xylotomous]

Hello, I was loathe to open an issue because I realize people are busy and I am a first-time user of this Sink. However, I was unable to source any solution or much information at all about this problem. I'll do my best to break it down with included information.

Serilog itself has been working for some months. There is both a Console sink and File sink in use. They both read properties from the appSettings without issue.

1. Configured this sink and received an exception that tableName cannot be null. It is in the appSettings Serilog config in the right location.
2. Configuring the name directly in code, the exception goes away and Serilog will use the Sink, applying the defaults only, and logging to Sql Server.
3. Used Serilog Selflog and saw the message: Unable to find a method called MSSqlServer

I assume this is the cause of the problem. Further interesting case, but fairly similar. I want LogEvent and not Properties and so amended my table in Sql Server to have the desired column and dropped Properties. If I do the same as above, configuring sinkOptions -> TableName = "Logs" and add/remove the columns from the Store in code, it will also proceed to log to Sql Server correctly. Serilog Selflog will still report it can't find the method MSSqlServer.

I have a few config changes from the default I require and will probably proceed with defining it all in code directly (I'm assuming it will work) as this is a very featureful Sink and I'd like to use it, thank you for providing it to the community.

More details, hopefully helpful

The project is using .net 8.x runtime, and is an AspNetCore application using 8.x packages of such.

Serilog packages are:

Serilog.AspNetCore Version="8.0.1"
Serilog.Settings.Configuration Version="8.0.0"
Serilog.Sinks.Console Version="5.0.0"
Serilog.Sinks.File Version="5.0.0"
Serilog.Sinks.MSSqlServer Version="8.2.2"

I initially tried with the latest Serilog.Sinks.MSSqlServer Version="9.0.2" as well

Included is the config file section, excluding the other sinks for brevity

"Serilog": { "Using": [ "Serilog.Sinks.MSSqlServer" ], "MinimumLevel": { "Default": "Information", "Override": { "Microsoft": "Warning", "System": "Warning" } }, "Enrich": [ "FromLogContext" ], "WriteTo": [ { "Name": "MSSqlServer", "Args": { "sinkOptionsSection": { "tableName": "Logs", "batchPostingLimit": 1000 }, "restrictedToMinimumLevel": "Information", "columnOptionsSection": { "disableTriggers": true, "clusteredColumnstoreIndex": false, "primaryKeyColumnName": "Id", "addStandardColumns": [ "LogEvent" ], "removeStandardColumns": [ "Properties" ], "id": { "nonClusteredIndex": true }, "level": { "storeAsEnum": false }, "timeStamp": { "columnName": "Timestamp", "convertToUtc": true, "DataType": "datetimeoffset" }, "logEvent": { "excludeAdditionalProperties": true, "excludeStandardColumns": true } } } } ] }

[Xylotomous]

I was able to successfully use the Sink provided it is completely configured in code. Anything in the appsettings,json is not found/seen.

[ckadluba]

hi @Xylotomous!

The JSON snippet you posted looks okay on the first glance but maybe it is misplaced in your appsettings.json or something else is hooked up wrong in you project.

Please take a look at our samples (especially https://github.com/serilog-mssql/serilog-sinks-mssqlserver/tree/dev/sample/WorkerServiceDemo) for a working program which reads MSSQL sink settings from from appsettings, just like you try to.

Cheers,
Christian

[Xylotomous]

Thank you, as far as I can tell everything is correct. The other defined sinks I am using work from the settings, and Serilog reports no other errors. I will try some deconstructing of the set up to a small test application to eliminate other possibilities and see if I can solve. The problem is very strange as I am sure it works for you and others!