C# 代码配置Log4Net连接加密Sqlite

1、创建加密的数据库：

2、创建数据表：

CREATE TABLE Log (

LogId INTEGER PRIMARY KEY,

Date DATETIME NOT NULL,

Thread VARCHAR (50) NOT NULL,

Level VARCHAR (50) NOT NULL,

Logger VARCHAR (255) NOT NULL,

Source VARCHAR (255) NOT NULL,

Message TEXT DEFAULT 'NULL',

Exception TEXT DEFAULT 'NULL'

);

3、创建 LogHelper 类

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using log4net.Appender;

using log4net.Config;

using log4net.Layout;

namespace TriageTool

{

public class LogHelper

{

public static readonly log4net.ILog logProxy = log4net.LogManager.GetLogger("logProxy");

/// <summary>

/// 使用SQLite记录异常日志

/// </summary>

public static void SetADONetAppender(string _ConnectionString)

{

log4net.Repository.Hierarchy.Hierarchy hier = log4net.LogManager.GetRepository() as log4net.Repository.Hierarchy.Hierarchy;

if (hier != null)

{

log4net.Appender.AdoNetAppender adoAppender = new log4net.Appender.AdoNetAppender();

adoAppender.Name = "AdoNetAppender";

adoAppender.CommandType = System.Data.CommandType.Text;

adoAppender.BufferSize = 1;

adoAppender.ConnectionType = "System.Data.SQLite.SQLiteConnection,System.Data.SQLite";//, Version = 1.0.66.0, Culture = neutral

adoAppender.ConnectionString = _ConnectionString;

adoAppender.CommandText = @"INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Source],[Message],[Exception]) VALUES"

" (@log_date, @thread, @log_level, @logger,@source, @message, @exception)";

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@log_date", DbType = System.Data.DbType.DateTime, Layout = new log4net.Layout.RawTimeStampLayout() });

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@thread", DbType = System.Data.DbType.String, Size = 255, Layout = new Layout2RawLayoutAdapter(new PatternLayout("%thread")) });

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@log_level", DbType = System.Data.DbType.String, Size = 50, Layout = new Layout2RawLayoutAdapter(new PatternLayout("%level")) });

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@logger", DbType = System.Data.DbType.String, Size = 255, Layout = new Layout2RawLayoutAdapter(new PatternLayout("%logger")) });

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@source", DbType = System.Data.DbType.String, Size = 255, Layout = new Layout2RawLayoutAdapter(new PatternLayout("%file:%line")) });

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@message", DbType = System.Data.DbType.String, Size = 4000, Layout = new Layout2RawLayoutAdapter(new PatternLayout("%message")) });

adoAppender.AddParameter(new AdoNetAppenderParameter { ParameterName = "@exception", DbType = System.Data.DbType.String, Size = 4000, Layout = new Layout2RawLayoutAdapter(new ExceptionLayout()) });

adoAppender.ActivateOptions();

BasicConfigurator.Configure(adoAppender);

}

}

}

}

4、初始化（传入数据库连接串）：LogHelper.SetADONetAppender(@"Data Source =" AppDomain.CurrentDomain.BaseDirectory "App_Data\\TriageTool_Log.db;Password=111111111111;");

5、调用： LogHelper.logProxy.Debug("test.");

遇到的坑：使用的System.Data.SQLite 为1.0.66.0，项目框架为.Net Framework 4.5，数据库未产生数据，需配置 App.Config

<startup useLegacyV2RuntimeActivationPolicy="true">

<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5"/>

<supportedRuntime version="v2.0.50727"/>

</startup>