使用Windsor城堡的NLog -如何将日志保存到数据库(.NET Core3.1)

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <targets>
    <target xsi:type="Database" name="databaseTarget" connectionString="your_connection_string">
      <commandText>
        INSERT INTO LogTable (LogLevel, Message, Exception) 
        VALUES (@level, @message, @exception)
      </commandText>
      <parameter name="@level" layout="${level}" />
      <parameter name="@message" layout="${message}" />
      <parameter name="@exception" layout="${exception:format=ToString}" />
    </target>
  </targets>

  <rules>
    <logger name="*" minlevel="Trace" writeTo="databaseTarget" />
  </rules>
</nlog>

using Microsoft.Extensions.Logging;
using NLog.Extensions.Logging;

public class Startup
{
    public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ILoggerFactory loggerFactory)
    {
        // ...

        // 添加NLog作为日志提供程序
        loggerFactory.AddNLog();

        // ...
    }
}

using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;

public class HomeController : Controller
{
    private readonly ILogger<HomeController> _logger;

    public HomeController(ILogger<HomeController> logger)
    {
        _logger = logger;
    }

    public IActionResult Index()
    {
        _logger.LogInformation("This is a log message.");

        return View();
    }
}