PigSQLSrvLib 2.8.106

.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. .NET Framework 2.0 This package targets .NET Framework 2.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 PigSQLSrvLib --version 2.8.106
NuGet\Install-Package PigSQLSrvLib -Version 2.8.106
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="PigSQLSrvLib" Version="2.8.106" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add PigSQLSrvLib --version 2.8.106
#r "nuget: PigSQLSrvLib, 2.8.106"
#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 PigSQLSrvLib as a Cake Addin
#addin nuget:?package=PigSQLSrvLib&version=2.8.106

// Install PigSQLSrvLib as a Cake Tool
#tool nuget:?package=PigSQLSrvLib&version=2.8.106

PigSQLSrvLib

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 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. 
.NET Core netcoreapp3.1 is compatible. 
.NET Framework net20 is compatible.  net30 is compatible.  net35 is compatible.  net40 is compatible.  net403 was computed.  net45 is compatible.  net451 was computed.  net452 was computed.  net46 is compatible.  net461 was computed.  net462 was computed.  net463 was computed.  net47 is compatible.  net471 was computed.  net472 was computed.  net48 is compatible.  net481 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 PigSQLSrvLib:

Package Downloads
PigSQLSrvLibDemo

Demo console program for PigSQLSrvLib
PigKeyCacheLib.SQLServer

PigKeyCacheLib.SQLServer is a very lightweight key value Caching Application support multi server load balancing.
PigKeyCacheLib.SQLServerDemo

Demo console program for PigKeyCacheLib.SQLServer
SeowHostLib

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.182 37 6/27/2024
2.8.180 31 6/27/2024
2.8.178 68 6/10/2024
2.8.176 68 6/5/2024
2.8.172 71 6/3/2024
2.8.170 109 3/25/2024
2.8.168 107 3/13/2024
2.8.166 97 2/19/2024
2.8.162 106 1/30/2024
2.8.160 84 1/24/2024
2.8.158 80 1/19/2024
2.8.156 124 1/3/2024
2.8.152 132 12/21/2023
2.8.150 112 12/12/2023
2.8.138 123 12/6/2023
2.8.136 103 11/23/2023
2.8.132 116 11/23/2023
2.8.130 95 11/10/2023
2.8.128 113 11/8/2023
2.8.126 89 11/6/2023
2.8.122.8 97 11/4/2023
2.8.120 186 10/17/2023
2.8.118 497 7/24/2023
2.8.116 210 6/24/2023
2.8.112 133 6/21/2023
2.8.110 500 6/15/2023
2.8.108 145 6/13/2023
2.8.106 155 6/11/2023
2.8.102 512 6/4/2023
2.8.100 151 6/1/2023
2.8.98 155 5/26/2023
2.8.96 150 5/23/2023
2.8.92 178 5/7/2023
2.8.90 149 5/4/2023
2.8.88 159 4/28/2023
2.8.86 170 4/27/2023
2.8.82 179 4/16/2023
2.8.80 200 4/14/2023
2.8.72 266 2/18/2023
2.8.70 287 2/1/2023
2.8.68 297 1/28/2023
2.8.66 292 1/20/2023
2.8.62 290 1/19/2023
2.8.60 300 1/18/2023
2.8.56 328 12/11/2022
2.8.50 329 11/28/2022
2.8.38 337 11/15/2022
2.8.36 353 11/12/2022
2.8.32 343 11/8/2022
2.8.30 362 11/2/2022
2.8.28 388 10/27/2022
2.8.26 411 10/22/2022
2.8.20 391 10/19/2022
2.8.18 396 10/17/2022
2.8.16 408 10/15/2022
2.8.12 425 10/12/2022
2.8.10 398 10/10/2022
2.8.8 407 10/4/2022
2.8.6 396 10/3/2022
2.7.102 439 9/28/2022
2.7.98 455 9/24/2022
2.7.96 467 9/18/2022
2.7.92 427 9/12/2022
2.7.80 415 8/31/2022
2.7.78 410 8/25/2022
2.7.76 428 8/17/2022
2.7.70 437 8/16/2022
2.7.68 446 8/14/2022
2.7.62 438 8/7/2022
2.7.60 455 8/5/2022
2.6.88 443 8/2/2022
2.6.78 447 8/1/2022
2.6.68 462 7/30/2022
2.6.28 465 7/29/2022
2.5.38 441 7/26/2022
2.5.30 449 7/19/2022
2.5.28 486 7/11/2022
2.5.18 435 7/10/2022
2.3.32 459 7/8/2022
2.3.28 463 7/4/2022
2.3.20 463 7/3/2022
2.2.32 480 6/26/2022
2.1.68 473 6/23/2022
2.1.50 464 6/16/2022
2.1.38 465 6/14/2022
2.1.28 447 6/13/2022
2.1.18 431 6/9/2022
2.0.26 454 6/8/2022
2.0.16 473 5/25/2022
1.8.16 498 1/14/2022
1.8.12 300 1/10/2022
1.7.38 292 12/28/2021
1.7.28 307 12/15/2021
1.6.18 335 12/5/2021
1.6.3 874 12/3/2021
1.5.38 357 11/14/2021
1.5.32 360 10/20/2021
1.5.28 360 10/8/2021
1.5.18 350 10/5/2021
1.5.5 343 9/24/2021
1.4.10 344 9/20/2021
1.3.3 351 9/7/2021
1.2.3 344 9/1/2021
1.1.8 367 8/29/2021
1.0.8.8 418 7/28/2021
1.0.7.16 381 7/21/2021
1.0.6.6 363 7/17/2021
1.0.5.8 373 7/12/2021
1.0.4.6 382 7/5/2021
1.0.3.18 400 6/21/2021
1.0.3.8 465 6/20/2021
1.0.2.2 375 6/12/2021
1.0.1.10 415 6/6/2021

Reference the latest class library.