Serilog.Sinks.MySql.Tvans 0.1.1-alpha

Serilog.Sinks.MySql.Tvans

Provides a Serilog Sink for MySql with customizability in columns, data types.

Example usage

Default

var logger = new LoggerConfiguration()
  .WriteTo.MySql("yourConnectionString")
  .CreateLogger();

Default with options for specified columns, or custom columns

var logger = new LoggerConfiguration()
  .WriteTo.MySql(
    "yourConnectionString", 
    MySqlSinkOptions.Default,
    MySqlColumnOptions.Default
      .With(new IdColumnOptions { DataType = new DataType(Kind.Guid), Name = "Id" })
      .With(new CustomColumnOptions 
      { 
        DataType = new DataType(Kind.Varchar, 128), 
        Name = "Application", 
        Value = "YourAppName" 
      }))
  .CreateLogger();

Options for sink and columns

var logger = new LoggerConfiguration()
  .WriteTo.MySql(
    "yourConnectionString",
    new MySqlSinkOptions 
    {
      tableName = "log_events",
      autoCreateTable = false,
    },
    new MySqlColumnOptions
    {
      IdColumnOptions = new IdColumnOptions { Name = "Guid", DataType = new DataType(Kind.Guid) },
      TimeStampColumnOptions = new TimeStampColumnOptions { Name = "TimeStamp", UseUtc = true }
      MessageTemplateColumnOptions = new MessageTemplateColumnOptions { Name = "Message" },
      LogEventColumnOptions = new LogEventColumnOptions 
      { 
        Name = "Properties", 
        EventSerializer = EventSerializer.Json 
      }
    })
  .CreateLogger();