[v2] Providers

MSSQL: Behind the scenes

The provider uses Microsoft.Data.SqlClient and Dapper to query the database.

DI registration options

• connectionString [required]
• tableName [required]
• schemaName [optional] (default is dbo)
• [from v2.2.3] dateTimeCustomParsing: a delegate to customize the Dapper DateTime parse. Delegate signature is Func<string, DateTime>. The return value of the signature must have DateTimeKind.UTC or the package will throw InvalidOperationException.

PostgreSQL: Behind the scenes

The provider uses Npgsql and Dapper to query the database.

DI registration options

• [from v2.3.0] sinkType [required] (the sink that used to store logs in the PostgreSQL database, Serilog.Sinks.Postgresql or Serilog.Sinks.Postgresql.Alternative)
• connectionString [required]
• tableName [required]
• schemaName [optional] (default is public)