Serilog:在不弄脏"message“字段的情况下写入自定义字段(mssql server)

using Serilog;
using Serilog.Sinks.MSSqlServer;

// 配置Serilog
Log.Logger = new LoggerConfiguration()
    .WriteTo.MSSqlServer(
        connectionString: "your_connection_string",
        tableName: "Logs",
        columnOptions: GetColumnOptions())
    .CreateLogger();

// 创建自定义字段的ColumnOptions
private static ColumnOptions GetColumnOptions()
{
    var columnOptions = new ColumnOptions();
    columnOptions.Store.Remove(StandardColumn.MessageTemplate);
    columnOptions.Store.Add(StandardColumn.LogEvent);
    columnOptions.LogEvent.ExcludeAdditionalProperties = true;
    columnOptions.LogEvent.ExcludeStandardColumns = true;
    return columnOptions;
}

// 在代码中使用Serilog记录日志
Log.Information("This is a log message with custom fields: {@CustomFields}", new { Field1 = "Value1", Field2 = "Value2" });

// 关闭Serilog
Log.CloseAndFlush();