private static MSSqlServerSinkOptions BuildSinkOptions(DbLoggingConfig dbLoggingConfig)
{
var batchPeriod = TimeSpan.FromSeconds(dbLoggingConfig.BatchPeriodSecs > 0 ? dbLoggingConfig.BatchPeriodSecs : 5);
var schemaName = dbLoggingConfig.SchemaName ?? "dbo";
var sinkOptions = new MSSqlServerSinkOptions
{
TableName = "Logs",
SchemaName = schemaName,
AutoCreateSqlTable = false,
BatchPostingLimit = 1000,
BatchPeriod = batchPeriod
};
return(sinkOptions);
}
private static string GetConnectionString(IConfiguration configuration, DbLoggingConfig dbLoggingConfig)
{
string connStr = null;
if (!string.IsNullOrWhiteSpace(dbLoggingConfig.ConnectionStringName))
{
connStr = configuration.GetConnectionString(dbLoggingConfig.ConnectionStringName);
}
if (string.IsNullOrWhiteSpace(connStr))
{
connStr = dbLoggingConfig.ConnectionString;
}
return(connStr);
}