Serilog.Sinks.MSSqlServer.MSSqlServerSinkOptions

public class MSSqlServerSinkOptions

Provides MSSqlServerSink with configurable options.

public bool AutoCreateSqlDatabase { get; set; }

Flag to automatically create the log events database if it does not exist (default: false)

public bool AutoCreateSqlTable { get; set; }

Flag to automatically create the log events table if it does not exist (default: false)

public TimeSpan BatchPeriod { get; set; }

Time span until a batch of log events is written to the database (default: 5 seconds)

public int BatchPostingLimit { get; set; }

Limits how many log events are written to the database per batch (default: 50)

public Action<SqlConnection> ConnectionConfiguration { get; set; }

Supplies an extension point for customizing the underyling SqlConnection

public bool EagerlyEmitFirstEvent { get; set; }

Flag to eagerly emit a batch containing the first received event (default: true)

public bool EnlistInTransaction { get; set; }

Flag to make logging SQL commands take part in ambient transactions (default: false)

public LoggingLevelSwitch LevelSwitch { get; set; }

A switch allowing the pass-through minimum level to be changed at runtime

public string SchemaName { get; set; }

Name of the database schema (default: "dbo")

public string TableName { get; set; }

Name of the database table for writing the log events

public bool UseSqlBulkCopy { get; set; }

Flag to use SqlBulkCopy instead of individual INSERT statements (default: true)

Initializes a new MSSqlServerSinkOptions instance with default values.