.NET Core NLog使用SQLite记录Log日志配置及示例代码

本文主要介绍.NET Core中，使用NLog将Log日志记录保存到SQLite数据库的配置方法及示例代码。

1､NLog使用SQLite的配置文件


http://www.nlog-project.org/schemas/NLog.xsd"
      xsi:schemaLocation="NLog NLog.xsd"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      autoReload="true"
      throwExceptions="true"
      internalLogIncludeTimestamp="true"
      internalLogFile="nlog-internal.log"
      internalLogLevel="Error">
    
                    name="db"
            dbProvider="System.Data.SQLite.SQLiteConnection, System.Data.SQLite"
            connectionString="Data Source=database.db;">
            
                insert into Logs (TimestampUtc, Application, Level, Message, Exception, Logger)
                values (@timestamputc, @application, @level, @message, @exception, @logger);

2､SQLite中建表语句

CREATE TABLE "Logs" ( 
    `Id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    `TimestampUtc` TEXT NOT NULL, 
    `Application` TEXT NOT NULL, 
    `Level` TEXT NOT NULL, 
    `Message` TEXT NOT NULL, 
    `Logger` TEXT NOT NULL, 
    `Exception` TEXT )

3､安装引用System.Data.SQLite Nuget包

Package Manager

PM> Install-Package System.Data.SQLite -Version 1.0.112

或

.NET CLI

> dotnet add package System.Data.SQLite --version 1.0.112

界面管理器安装方法：VS(Visual Studio)中Nuget的使用