Logger7.SqlServer 1.0.1

.NET 7.0 This package targets .NET 7.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package Logger7.SqlServer --version 1.0.1
                    


                    

                
NuGet\Install-Package Logger7.SqlServer -Version 1.0.1
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Logger7.SqlServer" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="Logger7.SqlServer" Version="1.0.1" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Logger7.SqlServer" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add Logger7.SqlServer --version 1.0.1
                    


                    

                
#r "nuget: Logger7.SqlServer, 1.0.1"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#:package Logger7.SqlServer@1.0.1
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=Logger7.SqlServer&version=1.0.1
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=Logger7.SqlServer&version=1.0.1
                    


                            Install as a Cake Tool

Logger7.SqlServer

介绍

ASP.Net7.0的日志

  1. 日志保存到SqlServer数据库
  2. 可查询
  3. 自动删除过期日志
安装教程
  1. Visual Studio程序包管理器控制台输入：install-package Logger7.SqlServer
  2. NuGet包管理器中搜索“Logger7.SqlServer”
使用说明

在Program.cs文件添加如下代码

        builder.AddSqlServerLogger("SqlServer连接字符串","日志表名称",是否创建日志表,日志保存天数,日志删除间隔天数);
日志表结构
/****** Object:  Table [dbo].[Logs]    Script Date: 2022/7/27 11:54:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Loggers](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](256) NOT NULL,
	[LogLevel] [nvarchar](16) NOT NULL,
	[Msg] [nvarchar](max) NOT NULL,
	[Dt] [datetime] NOT NULL,
 CONSTRAINT [PK_Logs] PRIMARY KEY CLUSTERED 
(
	[Id] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Product Compatible and additional computed target framework versions.
.NET net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
7.1.6 279 12/25/2023
7.1.5 195 12/24/2023
7.1.4 210 12/22/2023
7.1.3 194 12/21/2023
7.1.2 191 12/20/2023
7.1.1 210 12/20/2023
7.1.0 205 12/19/2023
7.0.6 194 12/18/2023
7.0.5 193 12/18/2023
7.0.4 200 12/18/2023
7.0.3 192 12/17/2023
7.0.2 186 12/14/2023
7.0.1 190 12/13/2023
1.0.4 212 12/5/2023
1.0.3 208 12/1/2023
1.0.2 204 12/1/2023
1.0.1 197 11/30/2023
1.0.0 171 11/30/2023