PigSQLSrvCoreLib 2.8.220

dotnet add package PigSQLSrvCoreLib --version 2.8.220
                    
NuGet\Install-Package PigSQLSrvCoreLib -Version 2.8.220
                    
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="PigSQLSrvCoreLib" Version="2.8.220" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="PigSQLSrvCoreLib" Version="2.8.220" />
                    
Directory.Packages.props
<PackageReference Include="PigSQLSrvCoreLib" />
                    
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 PigSQLSrvCoreLib --version 2.8.220
                    
#r "nuget: PigSQLSrvCoreLib, 2.8.220"
                    
#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 PigSQLSrvCoreLib@2.8.220
                    
#: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=PigSQLSrvCoreLib&version=2.8.220
                    
Install as a Cake Addin
#tool nuget:?package=PigSQLSrvCoreLib&version=2.8.220
                    
Install as a Cake Tool

PigSQLSrvCoreLib

An interface class library specially designed for MS-SQL server.

  • Friendly calling interface for Command of SQL Server StoredProcedure and SQL statement Text.
  • Support automatic switch connection of mirror database for high availability.
  • Support the transformation of query results into JSON and XML.
  • Key value based on SQL Server.
  • Support cache query.
  • Database connection management.
  • Generate SQL statements or VB code for tables or views.
  • Common SQL Server operation tool functions.
  • It can run on Windows and Linux platforms.
  • View demo
Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  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 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 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 is compatible.  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 (4)

Showing the top 4 NuGet packages that depend on PigSQLSrvCoreLib:

Package Downloads
PigSQLSrvCoreLibDemo

Demo console program for PigSQLSrvCoreLib

PigKeyCacheCoreLib.SQLServer

It is a very lightweight key value Caching Application support multi server load balancing.

PigKeyCacheCoreLib.SQLServerDemo

Demo console program for PigKeyCacheCoreLib.SQLServer

SeowHostCoreLib

This is a class library that handles host information, file and directory processing, and other functions.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
2.8.220 265 12/16/2025
2.8.218 202 9/10/2025
2.8.212 190 5/18/2025
2.8.210 230 2/13/2025
2.8.208 214 11/21/2024
2.8.206 210 11/20/2024
2.8.202 213 9/27/2024
2.8.200 212 8/27/2024
2.8.198 153 7/31/2024
2.8.196 197 7/23/2024
2.8.190 197 7/18/2024
2.8.188 254 7/14/2024
2.8.186 234 7/2/2024
2.8.182 212 6/27/2024
2.8.180 232 6/27/2024
2.8.178 188 6/10/2024
2.8.176 223 6/5/2024
2.8.172 217 6/3/2024
2.8.170 304 3/25/2024
2.8.168 275 3/13/2024
2.8.166 322 2/19/2024
2.8.162 269 1/30/2024
2.8.160 280 1/24/2024
2.8.158 282 1/19/2024
2.8.156 333 1/3/2024
2.8.152 303 12/21/2023
2.8.150 348 12/12/2023
2.8.138 214 12/6/2023
2.8.136 303 11/23/2023
2.8.132 262 11/23/2023
2.8.130 256 11/10/2023
2.8.128 281 11/8/2023
2.8.126 262 11/6/2023
2.8.122 303 11/4/2023
2.8.100 872 6/1/2023
2.8.98 690 5/26/2023
2.8.96 572 5/23/2023
2.8.92 584 5/7/2023
2.8.90 598 5/4/2023
2.8.88 685 4/28/2023
2.8.86 620 4/27/2023
2.8.82 789 4/16/2023
2.8.80 767 4/14/2023
2.8.72 787 2/18/2023
2.8.70 829 2/1/2023
2.8.68 961 1/28/2023
2.8.66 984 1/20/2023
2.8.62 734 1/19/2023
2.8.60 725 1/18/2023
2.8.56 994 12/11/2022
2.8.50 749 11/28/2022
2.8.38 782 11/16/2022
2.8.36 806 11/12/2022
2.8.32 781 11/8/2022
2.8.30 798 11/2/2022
2.8.28 848 10/27/2022
2.8.26 882 10/22/2022
2.8.20 1,294 10/19/2022
2.8.18 856 10/17/2022
2.8.16 1,309 10/15/2022
2.8.12 1,114 10/12/2022
2.8.10 839 10/10/2022
2.8.8 1,264 10/4/2022
2.8.6 1,050 10/3/2022
2.7.102 864 9/28/2022
2.7.98 1,113 9/24/2022
2.7.96 901 9/18/2022
2.7.92 883 9/12/2022
2.7.80 878 8/31/2022
2.7.78 1,097 8/25/2022
2.7.76 889 8/17/2022
2.7.70 874 8/16/2022
2.7.68 1,124 8/14/2022
2.7.62 882 8/6/2022
2.7.60 897 8/5/2022
2.6.88 1,297 8/2/2022
2.6.78 1,142 8/1/2022
2.6.68 905 7/30/2022
2.6.28 1,614 7/29/2022
2.5.38 1,349 7/26/2022
2.5.30 1,392 7/19/2022
2.5.28 1,634 7/11/2022
2.5.18 1,618 7/10/2022
2.3.32 1,649 7/8/2022
2.3.28 1,191 7/4/2022
2.3.20 1,200 7/3/2022
2.2.32 1,168 6/26/2022
2.1.68 1,112 6/23/2022
2.1.50 1,671 6/16/2022
2.1.38 1,678 6/14/2022
2.1.28 889 6/13/2022
2.1.18 1,120 6/9/2022
2.0.26 1,158 6/8/2022
2.0.16 1,167 5/25/2022
1.8.16 2,362 1/14/2022
1.8.12 2,060 1/10/2022
1.7.38 1,255 12/28/2021
1.7.28 1,150 12/15/2021
1.6.18 868 12/5/2021
1.6.10 882 12/3/2021
1.6.8 1,248 11/14/2021
1.5.30 1,301 10/10/2021
1.5.28 1,072 10/8/2021
1.5.18 1,252 10/5/2021
1.5.5 988 9/24/2021
1.4.6 1,246 9/20/2021
1.3.3 958 9/9/2021
1.2.5 927 9/1/2021
1.1.8 986 8/29/2021
1.0.7.3 978 7/29/2021
1.0.6.8 931 7/22/2021
1.0.5.2 924 7/17/2021
1.0.4.8 944 7/9/2021
1.0.4.3 940 7/6/2021
1.0.3.6 963 6/22/2021
1.0.2.5 974 6/13/2021
1.0.1.5 945 6/7/2021

Fix bugs of CmdSQLSrvSp and CmdSQLSrvText.