serilog-sinks-mssqlserver:排除 xml 配置文件中的列

Question

如何排除xml配置文件中的列？

我想做这个 serilogColumnOptions.Store.Remove(StandardColumn.Properties); 配置文件中的事件

Answer 1

似乎无法通过 XML 配置删除 Serilog 列。

我找到了对这种说法的几个确认：这里和这里。

还可以通过检查 SQL Server 接收器的源代码来验证这一点：

MSSqlServer()扩展方法检查MSSqlServerSettingsSection用于配置列的部分，如文档中所述。

MSSqlServerConfigurationSection serviceConfigSection =
ConfigurationManager.GetSection("MSSqlServerSettingsSection") as MSSqlServerConfigurationSection;
// If we have additional columns from config, load them as well
if (serviceConfigSection != null && serviceConfigSection.Columns.Count > 0)
{
if (columnOptions == null)
{
columnOptions = new ColumnOptions();
}
GenerateDataColumnsFromConfig(serviceConfigSection, columnOptions);
}

如果随后检查GenerateDataColumnsFromConfig()方法，您将看到所有配置的列都刚刚添加到AdditionalDataColumnsColumnOptions集合中。 但是没有任何代码可以从集合中删除Store列。

如果您的应用程序必须具有 Serilog 的文件配置并有可能删除某些列，则可以从文件中添加 Serilog 配置的简单替换。下面是此类配置的示例实现：

var connectionString = ConfigurationManager.AppSettings["serilog:write-to:MSSqlServer.connectionString"];
var tableName = ConfigurationManager.AppSettings["serilog:write-to:MSSqlServer.tableName"];
var autoCreateSqlTable = Convert.ToBoolean(ConfigurationManager.AppSettings["serilog:write-to:MSSqlServer.autoCreateSqlTable"]);
var excludedColumns = ConfigurationManager.AppSettings["serilog:write-to:MSSqlServer.excludedColumns"];
ColumnOptions columnOptions = new ColumnOptions();
foreach (var excludedColumn in Regex.Split(excludedColumns, ",\s*"))
{
columnOptions.Store.Remove((StandardColumn)Enum.Parse(typeof(StandardColumn), excludedColumn, true));
}
Logger log = new LoggerConfiguration()
.WriteTo.MSSqlServer(connectionString, tableName, columnOptions: columnOptions, autoCreateSqlTable: autoCreateSqlTable)
.CreateLogger();

这是appSettings部分：

<appSettings>
<add key="serilog:using:MSSqlSever" value="Serilog.Sinks.MSSqlServer" />
<add key="serilog:write-to:MSSqlServer.connectionString" value="Server=.;Database=LoggingDB;Trusted_Connection=True;"/>
<add key="serilog:write-to:MSSqlServer.tableName" value="Logs"/>
<add key="serilog:write-to:MSSqlServer.autoCreateSqlTable" value="true"/>
<add key="serilog:write-to:MSSqlServer.excludedColumns" value="Properties, TimeStamp"/>
</appSettings>

希望这对您有所帮助。