1、安装依赖包
log4net:
NuGet\Install-Package log4net -Version 2.0.16
Microsoft.Extensions.Logging.Log4Net.AspNetCore:
NuGet\Install-Package Microsoft.Extensions.Logging.Log4Net.AspNetCore -Version 8.0.0
System.Data.SqlClient:
NuGet\Install-Package System.Data.SqlClient -Version 4.8.6
2、准备配置文件Log4Net.config
注意创建数据库表,并更改数据库连接字符串
<?xml version="1.0" encoding="utf-8" ?>
<log4net>
<!--Define some output appenders-->
<!--文本日志-->
<appender name ="rollingAppender" type="log4net.Appender.RollingFileAppender">
<file value ="Logs\Log4Net\Log4Net"/>
<!--追加日志内容-->
<appendToFile value="true"/>
<!--防止多线程不能写Log,官方说线程非安全-->
<lockingModel type="log4net.Appender.FileAppender+MinimalLock"/>
<!--可以为:Once|Size|Date|Composite-->
<!--Composite为Size和Date的组合-->
<rollingStyle value="Composite"/>
<!--当备份文件时,为文件名加的后缀-->
<datePattern value="yyyyMMdd.TXT"/>
<!--日志最大个数,都是最新的-->
<!--rollingStyle节点为Size时,只能有value个日志-->
<!--rollingStyle节点为Composite时,每天有value个日志-->
<maxSizeRollBackups value="20"/>
<!--可用的单位:KB|MB|GB-->
<maximumFileSize value="3MB"/>
<!--置为true,当前最新日志文件名永远为file节中的名字-->
<staticLogFileName value="false"/>
<!--输出级别在INFO和ERROR之间的日志-->
<filter type="log4net.Filter.LevelRangeFilter">
<param name="LevelMin" value="ALL"/>
<param name="LevelMax" value="FATAL"/>
</filter>
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date [%thread] %-5level %logger - %message%newline"/>
</layout>
</appender>
<!--SQLServer形式日志-->
<!--log4net日志配置:https://logging.apache.org/log4net/release/config-examples.html-->
<!--新建表:
CREATE TABLE [dbo].[Log4Net] (
[Id] [int] IDENTITY (1, 1) NOT NULL,
[Date] [datetime] NOT NULL,
[Thread] [varchar] (255) NOT NULL,
[Level] [varchar] (50) NOT NULL,
[Logger] [varchar] (255) NOT NULL,
[Message] [varchar] (4000) NOT NULL,
[Exception] [varchar] (2000) NULL)
-->
<!--执行下面命令安装System.Data.SqlClient-->
<!--NuGet\Install-Package System.Data.SqlClient -Version 4.8.6-->
<!--bufferSize为日志缓存写入条数,设置为0代表只要有一条数据就立刻写入到数据库中-->
<appender name="AdoNetAppender_SQLServer" type="log4net.Appender.AdoNetAppender">
<bufferSize value="0" />
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<connectionString value="data source=;initial catalog=demo1;User ID=;Password=" />
<commandText value="INSERT INTO Log4Net ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
<parameter>
<parameterName value="@log_date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.RawTimeStampLayout" />
</parameter>
<parameter>
<parameterName value="@thread" />
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%thread" />
</layout>
</parameter>
<parameter>
<parameterName value="@log_level" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<parameter>
<parameterName value="@logger" />
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%logger" />
</layout>
</parameter>
<parameter>
<parameterName value="@message" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%message" />
</layout>
</parameter>
<parameter>
<parameterName value="@exception" />
<dbType value="String" />
<size value="2000" />
<layout type="log4net.Layout.ExceptionLayout" />
</parameter>
</appender>
<root>
<!--控制级别,由低到高:ALL|DEBUG|INFO|WARN|ERROR|FATAL|OFF-->
<!--OFF:0-->
<!--FATAL:FATAL-->
<!--ERROR:ERROR,FATAL-->
<!--WARN:WARN,ERROR,FATAL-->
<!--INFO:INFO,WARN,ERROR,FATAL-->
<!--DEBUG:INFO,WARN,ERROR,FATAL-->
<!--ALL:DEBUG,INFO,WARN,ERROR,FATAL-->
<priority value="ALL"/>
<level value="INFO" />
<appender-ref ref="rollingAppender" />
<appender-ref ref="AdoNetAppender_SQLServer" />
</root>
</log4net>
3、Program.cs中配置
builder.Logging.AddLog4Net("CfgFile/Log4Net.Config"); //配置文件路径
builder.Logging.SetMinimumLevel(Microsoft.Extensions.Logging.LogLevel.Information);//设置最低级别
4、使用:在需要记录日志的Controller中添加
private readonly ILogger<A01BaseController> _logger;
public A01BaseController(ILogger<A01BaseController> logger)
{
_logger = logger;
_logger.LogInformation($"LogInformation: {this.GetType().FullName}被构造...");
_logger.LogError($"LogError: {this.GetType().FullName}被构造...");
_logger.LogDebug($"LogDebug: {this.GetType().FullName}被构造...");
_logger.LogWarning($"LogWarning: {this.GetType().FullName}被构造...");
}