PigSQLSrvCoreLib 2.8.190

.NET 5.0 This package targets .NET 5.0. The package is compatible with this framework or higher. .NET Core 3.1 This package targets .NET Core 3.1. 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 PigSQLSrvCoreLib --version 2.8.190                

                    
                

            
NuGet\Install-Package PigSQLSrvCoreLib -Version 2.8.190
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.190" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add PigSQLSrvCoreLib --version 2.8.190                

                    
                

            
#r "nuget: PigSQLSrvCoreLib, 2.8.190"
#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. 
// Install PigSQLSrvCoreLib as a Cake Addin
#addin nuget:?package=PigSQLSrvCoreLib&version=2.8.190

// Install PigSQLSrvCoreLib as a Cake Tool
#tool nuget:?package=PigSQLSrvCoreLib&version=2.8.190

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. 
.NET Core netcoreapp3.1 is compatible. 
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.208 38 11/21/2024
2.8.206 48 11/20/2024
2.8.202 89 9/27/2024
2.8.200 98 8/27/2024
2.8.198 64 7/31/2024
2.8.196 94 7/23/2024
2.8.190 94 7/18/2024
2.8.188 127 7/14/2024
2.8.186 110 7/2/2024
2.8.182 109 6/27/2024
2.8.180 109 6/27/2024
2.8.178 95 6/10/2024
2.8.176 101 6/5/2024
2.8.172 100 6/3/2024
2.8.170 162 3/25/2024
2.8.168 148 3/13/2024
2.8.166 180 2/19/2024
2.8.162 151 1/30/2024
2.8.160 145 1/24/2024
2.8.158 147 1/19/2024
2.8.156 198 1/3/2024
2.8.152 169 12/21/2023
2.8.150 202 12/12/2023
2.8.138 146 12/6/2023
2.8.136 198 11/23/2023
2.8.132 168 11/23/2023
2.8.130 175 11/10/2023
2.8.128 185 11/8/2023
2.8.126 174 11/6/2023
2.8.122 197 11/4/2023
2.8.100 613 6/1/2023
2.8.98 493 5/26/2023
2.8.96 388 5/23/2023
2.8.92 407 5/7/2023
2.8.90 419 5/4/2023
2.8.88 507 4/28/2023
2.8.86 421 4/27/2023
2.8.82 563 4/16/2023
2.8.80 530 4/14/2023
2.8.72 564 2/18/2023
2.8.70 616 2/1/2023
2.8.68 742 1/28/2023
2.8.66 762 1/20/2023
2.8.62 537 1/19/2023
2.8.60 533 1/18/2023
2.8.56 793 12/11/2022
2.8.50 546 11/28/2022
2.8.38 577 11/16/2022
2.8.36 609 11/12/2022
2.8.32 577 11/8/2022
2.8.30 590 11/2/2022
2.8.28 632 10/27/2022
2.8.26 673 10/22/2022
2.8.20 1,052 10/19/2022
2.8.18 646 10/17/2022
2.8.16 1,088 10/15/2022
2.8.12 908 10/12/2022
2.8.10 651 10/10/2022
2.8.8 1,021 10/4/2022
2.8.6 829 10/3/2022
2.7.102 677 9/28/2022
2.7.98 881 9/24/2022
2.7.96 714 9/18/2022
2.7.92 675 9/12/2022
2.7.80 681 8/31/2022
2.7.78 879 8/25/2022
2.7.76 681 8/17/2022
2.7.70 673 8/16/2022
2.7.68 896 8/14/2022
2.7.62 669 8/6/2022
2.7.60 676 8/5/2022
2.6.88 1,030 8/2/2022
2.6.78 919 8/1/2022
2.6.68 692 7/30/2022
2.6.28 1,345 7/29/2022
2.5.38 1,107 7/26/2022
2.5.30 1,162 7/19/2022
2.5.28 1,385 7/11/2022
2.5.18 1,359 7/10/2022
2.3.32 1,398 7/8/2022
2.3.28 965 7/4/2022
2.3.20 973 7/3/2022
2.2.32 932 6/26/2022
2.1.68 898 6/23/2022
2.1.50 1,396 6/16/2022
2.1.38 1,429 6/14/2022
2.1.28 664 6/13/2022
2.1.18 898 6/9/2022
2.0.26 932 6/8/2022
2.0.16 947 5/25/2022
1.8.16 2,052 1/14/2022
1.8.12 1,774 1/10/2022
1.7.38 979 12/28/2021
1.7.28 923 12/15/2021
1.6.18 642 12/5/2021
1.6.10 633 12/3/2021
1.6.8 985 11/14/2021
1.5.30 1,041 10/10/2021
1.5.28 825 10/8/2021
1.5.18 977 10/5/2021
1.5.5 743 9/24/2021
1.4.6 978 9/20/2021
1.3.3 718 9/9/2021
1.2.5 701 9/1/2021
1.1.8 742 8/29/2021
1.0.7.3 753 7/29/2021
1.0.6.8 691 7/22/2021
1.0.5.2 705 7/17/2021
1.0.4.8 691 7/9/2021
1.0.4.3 696 7/6/2021
1.0.3.6 720 6/22/2021
1.0.2.5 714 6/13/2021
1.0.1.5 710 6/7/2021

Optimize CmdSQLSrvSp and CmdSQLSrvText.