使用多线程Nlog在数据库中写入日志的问题

var config = new LoggingConfiguration();
var asyncTarget = new AsyncTargetWrapper(new DatabaseTarget());
config.AddTarget("asyncDb", asyncTarget);
config.AddRule(LogLevel.Info, LogLevel.Fatal, asyncTarget);
LogManager.Configuration = config;

<target name="database" xsi:type="Database">
    <connectionString>Server=localhost;Database=Logs;Trusted_Connection=True;Pooling=true;Max Pool Size=50;</connectionString>
    <!-- 其他配置 -->
</target>

public void LogToDatabase(LogEventInfo logEvent)
{
    using (var transaction = new TransactionScope())
    {
        try
        {
            // 执行日志写入操作
            transaction.Complete();
        }
        catch (Exception ex)
        {
            // 处理异常
        }
    }
}

public void Log(LogEventInfo logEvent)
{
    // 提取关键信息
    var simplifiedLog = new { logEvent.TimeStamp, logEvent.Level, logEvent.Message };
    // 异步写入数据库
    Task.Run(() => LogToDatabase(simplifiedLog));
}