.Net 6 Log4Net-【.Net Core】

一：

 1.NuGet引入程序包：

1.Log4Net
2.Microsoft.Extensions.Logging.Log4Net.AspNetCore

 2.准备好配置文件：CfgFile--官网可以下载

 3.配置读取文件生效，注册 【Program.cs】

WebApplicationBuilder builder = WebApplication.CreateBuilder(args);//var builder=>update==> WebApplicationBuilder builder

{
    //Nuget引入
    //1.Log4Net
    //2.Microsoft.Extensions.Logging.Log4Net.AspNetCore
    builder.Logging.AddLog4Net("CfgFile/log4net.Config");
}

 注意：修改文件属性

4.注入得到Log4Net实例开始记录日志 新增的控制器【SecondController】

public class SecondController : Controller
    {
        //1.定义
        private readonly ILogger _logger;
        private readonly ILoggerFactory _factory;
        public SecondController(ILogger logger,ILoggerFactory factory)
        {
            this._logger = logger;
            this._logger.LogInformation($"{this.GetType().Name}被构造了:_logger");

            this._factory = factory;
            ILogger _logger1 = _factory.CreateLogger();
            _logger1.LogInformation($"{this.GetType().Name}被构造了:_logger1");
        }
        public IActionResult Index()
        {
            this._logger.LogInformation($"Index被执行了");

            ILogger _logger2 = _factory.CreateLogger();
            _logger2.LogInformation($"{this.GetType().Name}被执行了:_logger2");

            return View();
        }
    }

 这是结果：

二.Log4Net日志写SqlServer

1.Nuget以来程序包引入；

System.Data.SqlClient

2.修改配置文件：支持写数据库日志

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

    
    
    "rollingAppender" type="log4net.Appender.RollingFileAppender">
        "log4\log.txt" />
        
        "true" />

        
        "log4net.Appender.FileAppender+MinimalLock" />

        
        
        "Composite" />

        
        "yyyyMMdd.TXT" />

        
        
        
        "20" />

        
        "3MB" />

        
        "true" />

        
        "log4net.Filter.LevelRangeFilter">
            "LevelMin" value="ALL" />
            "LevelMax" value="FATAL" />
        
        "log4net.Layout.PatternLayout">
            "%date [%thread] %-5level %logger - %message%newline"/>
        
    

    
    
    "AdoNetAppender_SqlServer" type="log4net.Appender.AdoNetAppender">
        
        "0" />
        "System.Data.SqlClient.SqlConnection,System.Data.SqlClient, Version=4.6.1.3, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
        "Data Source=.;Initial Catalog=LogManager;Persist Security Info=True;User ID=sa;Password=123456" />
        "INSERT INTO Log4Net ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
        
            "@log_date" />
            "DateTime" />
            "log4net.Layout.RawTimeStampLayout" />
        
        
            "@thread" />
            "String" />
            "255" />
            "log4net.Layout.PatternLayout">
                "%thread" />
            
        
        
            "@log_level" />
            "String" />
            "50" />
            "log4net.Layout.PatternLayout">
                "%level" />
            
        
        
            "@logger" />
            "String" />
            "255" />
            "log4net.Layout.PatternLayout">
                "%logger" />
            
        
        
            "@message" />
            "String" />
            "4000" />
            "log4net.Layout.PatternLayout">
                "%message" />
            
        
        
            "@exception" />
            "String" />
            "2000" />
            "log4net.Layout.ExceptionLayout" />
        
    
    
    

        
        
        
        
        
        
        
         
        "ALL"/>

        
        "INFO"/>
        ref ref="rollingAppender" />
        ref ref="AdoNetAppender_SqlServer" />
    

3.初始化数据库日志表

/* 
脚本包含:
    1.了Log4Net写数据库日志脚本
    2. Nlog写数据库日志脚本
*/
USE [master]
GO
 
/* 
  创建数据库LogManager
*/
CREATE DATABASE [LogManager];
 
 
GO
ALTER DATABASE [LogManager] SET COMPATIBILITY_LEVEL = 150
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [LogManager].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [LogManager] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [LogManager] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [LogManager] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [LogManager] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [LogManager] SET ARITHABORT OFF 
GO
ALTER DATABASE [LogManager] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [LogManager] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [LogManager] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [LogManager] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [LogManager] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [LogManager] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [LogManager] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [LogManager] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [LogManager] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [LogManager] SET  DISABLE_BROKER 
GO
ALTER DATABASE [LogManager] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [LogManager] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [LogManager] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [LogManager] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [LogManager] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [LogManager] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [LogManager] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [LogManager] SET RECOVERY FULL 
GO
ALTER DATABASE [LogManager] SET  MULTI_USER 
GO
ALTER DATABASE [LogManager] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [LogManager] SET DB_CHAINING OFF 
GO
ALTER DATABASE [LogManager] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [LogManager] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [LogManager] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [LogManager] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
EXEC sys.sp_db_vardecimal_storage_format N'LogManager', N'ON'
GO
ALTER DATABASE [LogManager] SET QUERY_STORE = OFF
GO
USE [LogManager]
GO
/****** Object:  Table [dbo].[Log4Net]    Script Date: 2021/11/26 10:56:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/* 
  创建Log4net的表
*/

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
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[NLog]    Script Date: 2021/11/26 10:56:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/* 
  创建Log4net的表
*/

CREATE TABLE [dbo].[NLog](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Application] [nvarchar](50) NOT NULL,
    [Logged] [datetime] NOT NULL,
    [Level] [nvarchar](50) NOT NULL,
    [Message] [nvarchar](max) NOT NULL,
    [Logger] [nvarchar](250) NULL,
    [Callsite] [nvarchar](max) NULL,
    [Exception] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Log] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
USE [master]
GO
ALTER DATABASE [LogManager] SET  READ_WRITE 
GO

 4.注入写日志测试;需要在上面的基础上直接操作

结果：