.NET Core+NLog+存储配置 日志存入到数据库

nlog-config.xml 配置文件：

<?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"
      autoReload="false"
      internalLogLevel="info"
      internalLogFile="Logs/SysNlog.log">

  <extensions>
    <add assembly="NLog.Web.AspNetCore"/>
  </extensions>

  <targets>
    <target name="db"
            xsi:type="Database"
            connectionString="${var:NLOG_CONNECTION_STRING}"
            commandType="StoredProcedure"
            commandText="[dbo].[SP_InsertLog]">
      <parameter name="@traceId" layout="${aspnet-TraceIdentifier}" />
      <parameter name="@eventId" layout="${event-properties:EventId}" />
      <parameter name="@user" layout="${aspnet-user-identity}" />
      <parameter name="@application" layout="APP_WEB" />
      <parameter name="@level" layout="${level}" />
      <parameter name="@category" layout="${logger}" />
      <parameter name="@message" layout="${message}" />
      <parameter name="@properties" layout="${all-event-properties:separator=|}" />
      <parameter name="@exception" layout="${exception:tostring}" />
      <parameter name="@clientIP" layout="${aspnet-request-ip}" />
      <parameter name="@addTime" layout="${date:universalTime=True}" />
    </target>
  </targets>

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

 appsettings.json配置

{
  "ConnectionStrings": {
    "testDatabase": "Data Source=(local); Initial Catalog=TestDB; User Id=sa; Password=Sa; MultipleActiveResultSets=True;",
    "LogDatabase": "Data Source=(local); Initial Catalog=TestDB_Log; User Id=sa; Password=Sa; MultipleActiveResultSets=True;"
  },
 "Encoding": "GBK",
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Microsoft.AspNetCore.Mvc": "Warning",
      "Microsoft.EntityFrameworkCore": "Warning",
      "Default": "Information"
    }
  }
}

 STARTUP.CS

        //  NLog 数据库配置
            NLog.LogManager.Configuration.FindTargetByName<DatabaseTarget>("db").ConnectionString = Configuration.GetConnectionString("LogDatabase");

 存储：

create procedure [dbo].[SP_InsertLog](
    @traceId nvarchar(32),
    @eventId int,
    @user nvarchar(450),
    @application nvarchar(450),
    @level nvarchar(8),
    @category nvarchar(450),
    @message nvarchar(max),
    @properties nvarchar(max),
    @exception nvarchar(max),
    @clientIP nvarchar(450),
    @addTime datetime
)
as
begin
    insert into dbo.[LogTable]([TraceId],[EventId], [User], [Application], [Level], [Category], [Message], [Properties], [Exception], [ClientIP], [AddTime]) 
        values(@traceId, @eventId, @user, @application, @level, @category, @message, @properties, @exception, @clientIP, @addTime);
end

 Program.cs

 

 public class Program
    {
        public static void Main(string[] args)
        {
            var logger = NLogBuilder.ConfigureNLog("Log/nlog-config.xml").GetCurrentClassLogger();
            try
            {
                CreateWebHostBuilder(args).Build().Run();
            }
            catch (Exception ex)
            {
                logger.Error(ex, "异常信息");
                throw;
            }
            finally { NLog.LogManager.Shutdown(); }
        }

        public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
            WebHost.CreateDefaultBuilder(args)
                .UseStartup<Startup>()
                .UseNLog();
    }