.netCorr8.0 持久化Nlog日志到数据库(mysql)

安装相关软件包

NLog(5.3.1)
NLog.Database(5.3.1)
NLog.Web.AspNetCore(5.3.9)
MySql.Data(8.3.0)

Nlog.config配置文件

<?xml version="1.0" encoding="utf-8" ?>

<targets>
    <target xsi:type="Database"
            name="mysql"
            dbProvider="MySql.Data.MySqlClient.MySqlConnection,MySql.Data"
            connectionString="server=192.168.30.203;user=root;database=blog;port=3306;password=123456;">
        <commandText>
            INSERT INTO log_NLog (machineName, logged, level, message, logger, callSite, exception)
            VALUES (@machineName, @logged, @level, @message, @logger, @callSite, @exception)
        </commandText>
        <parameter name="@machineName" layout="${machinename}" />
        <parameter name="@logged" layout="${date}" />
        <parameter name="@level" layout="${level}" />
        <parameter name="@message" layout="${message}" />
        <parameter name="@logger" layout="${logger}" />
        <parameter name="@callSite" layout="${callsite}" />
        <parameter name="@exception" layout="${exception:tostring}" />
    </target>
    <target xsi:type="File" name="internalLog" fileName="internal-nlog.txt" layout="${longdate} ${level} ${message}" />
</targets>

<rules>
    <logger name="*" minlevel="Info" writeTo="mysql" />
</rules>

<internalLogging target="internalLog" level="Info" />

progroam.cs注册Nlog

builder.Logging.ClearProviders();
builder.Logging.AddNLog(“NLog.config”);
builder.Host.UseNLog();

API接口构造函数注入Nlog并使用

swagger测试调用接口写入mysql数据库成功