JCoder.CoreKits.SqlServer 3.2623.1

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. .NET Standard 2.1 This package targets .NET Standard 2.1. The package is compatible with this framework or higher. .NET Framework 4.7.2 This package targets .NET Framework 4.7.2. The package is compatible with this framework or higher. 
dotnet add package JCoder.CoreKits.SqlServer --version 3.2623.1
                    


                    

                
NuGet\Install-Package JCoder.CoreKits.SqlServer -Version 3.2623.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="JCoder.CoreKits.SqlServer" Version="3.2623.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="JCoder.CoreKits.SqlServer" Version="3.2623.1" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="JCoder.CoreKits.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 JCoder.CoreKits.SqlServer --version 3.2623.1
                    


                    

                
#r "nuget: JCoder.CoreKits.SqlServer, 3.2623.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 JCoder.CoreKits.SqlServer@3.2623.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=JCoder.CoreKits.SqlServer&version=3.2623.1
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=JCoder.CoreKits.SqlServer&version=3.2623.1
                    


                            Install as a Cake Tool

JCoder.CoreKits.SqlServer

| 属性 | | | --------------- | -------------------------------------------- | | 作者(Authors) | Jackie Law | | 版权(Copyright) | Copyright © Jackie Law. All rights reserved. | | 协议 | MIT | | 联系(QQ) | 1378071853 | | 联系(Wechat) | JackieLaw1024 | | 联系(Email) | JackieLaw-dev@outlook.com |

目录

[TOC]

一.架构说明

JCoder.CoreKits.SqlServer
语言 C#
协议 MIT
.Net框架 .Net Standard2.1; .Net Framework 4.7.2; .Net 6; .Net 8; .Net 10;
简述 一款使用SqlServer进行辅助的工具库。

1.1 引用类库

引用类库 版本
- -

1.2 相关类库

| 相关类库 | 说明 | | ---------------------------------------------------------------------------------- | --------------------------------------------------------------------------------- | | JCoder | The base library of JCoder Serial.（JCoder库系列的基础库。） | | JCoder.CoreKits | A simple library for C# extension.（一款简易的用于C#的扩展库。） | | JCoder.Db4Net | 一款为方便使用数据库的操作类库。 | | JCoder.Db4Net.SqlServer| 一个基于JCoder.Db4Net且支持SqlServer的库。 | | JCoder.Text4Net | A simple library for text.（一款简易的用于文本处理的扩展库。） |

获取方式

  1. 版本要求：>=2.1
  2. 以版本2.1为例

| 获取方式 | 描述 | | ------------------ | -------------------------------------------- | | Package Manager | Install-Package JCoder.CoreKits.SqlServer -Version 2.1 | | .Net CLI | dotnet add package JCoder.CoreKits.SqlServer --version 2.1 | | PackageReference | <PackageReference Include="JCoder.CoreKits.SqlServer" Version="2.1" /> | | Paket CLI | paket add JCoder.CoreKits.SqlServer --version 2.1 | | Script&Interactive | #r "nuget: JCoder.CoreKits.SqlServer, 2.1"| | Cake | // Install JCoder.CoreKits.SqlServer as a Cake Addin<br/>#addin nuget:?package=JCoder.CoreKits.SqlServer&version=2.1<br/><br/>// Install JCoder.CoreKits.SqlServer as a Cake Tool<br/>#tool nuget:?package=JCoder.CoreKits.SqlServer&version=2.1 |

三.使用说明

本库基于 SqlServer 提供辅助工具，包括基于 SqlServer 的日志记录器与历史数据存储器。

3.1 主要类与接口

| 名称 | 类型 | 描述 | | ---------------------- | ------ | -------------------------------------------------------------------------------- | | SqlServerLogger | 类 | 日志记录器(SqlServer)，实现 ILogger，提供日志写入、读取、清理功能。 | | SqlServerHistorian | 类 | 历史数据存储器(SqlServer)，实现 IHistorian，提供文本历史记录的存储与查询。 | | SqlServerLogConfig | 类 | SqlServer 日志配置，包含队列容量、批量写入大小等。 | | SqlServerLocalDber | 类 | 本地数据处理器(SqlServer)，实现 ILocalDber，提供本地数据的写入、读取功能。 | | LogRotationInterval | 枚举 | 日志轮转间隔（None/Hourly/Daily/Weekly/Monthly/Yearly）。 |

3.2 使用方法

  1. 使用 SqlServerLogger 记录日志
using JCoder.CoreKits.SqlServer;

// 创建日志记录器，并指定连接信息
var _logger = new SqlServerLogger
{
    Server = "localhost",      // 服务器地址
    Port = 1433,               // 端口
    Database = "jcoderkit",    // 数据库名称（不存在时自动创建）
    UserId = "sa",             // 用户名
    Password = "123456",       // 密码
};

// 写入信息日志（sender: 触发源, message: 日志内容）
_logger.Writer.Write(this, "系统启动成功");

// 写入分类日志（category: 日志分类）
_logger.Writer.Write(this, "Info", "系统启动成功");
_logger.Writer.Write(this, "Error", "发生异常：数据库连接失败");
_logger.Writer.Write(this, "Warning", "内存使用率超过80%");

// 写入异常日志
try { /* ... */ }
catch (Exception _ex) { _logger.Writer.Write(this, _ex); }
  1. 直接使用连接字符串
using JCoder.CoreKits.SqlServer;

var _logger = new SqlServerLogger
{
    ConnectionString = "Server=localhost,1433;Database=jcoderkit;User Id=sa;Password=123456;",
};
_logger.Writer.Write(this, "Info", "自定义连接配置日志");
  1. 使用 SqlServerHistorian 存储历史数据
using JCoder.CoreKits.SqlServer;

// 创建历史存储器（可设置 Server/Port/Database/UserId/Password 或 ConnectionString）
var _historian = new SqlServerHistorian
{
    Server = "localhost",
    Database = "jcoderkit",
    UserId = "sa",
    Password = "123456",
};

// 保存单条文本记录（key-value 方式）
_historian.SaveText("lastUser", "Jack");

// 读取单条文本记录
string _user = _historian.GetText("lastUser"); // "Jack"

// 向分组追加记录
_historian.AddGroupTexts("sensor1", "温度=25.6");
_historian.AddGroupTexts("sensor1", "湿度=60%");

// 读取分组记录列表
var _records = _historian.GetGroupTexts("sensor1");
foreach (var _record in _records)
{
    Console.WriteLine(_record);
}
Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  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 is compatible.  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 is compatible.  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. 
.NET Core netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.1 is compatible. 
.NET Framework net472 is compatible.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos 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
3.2623.1 53 9/28/2026

Please contact Jackie by QQ 1378071853 or E-mail JackieLaw-dev@outlook.com;