SujaySarma.Data.SqlServer 9.1.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. 
dotnet add package SujaySarma.Data.SqlServer --version 9.1.0                

                    
                

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

                    
                

            
#r "nuget: SujaySarma.Data.SqlServer, 9.1.0"
#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 SujaySarma.Data.SqlServer as a Cake Addin
#addin nuget:?package=SujaySarma.Data.SqlServer&version=9.1.0

// Install SujaySarma.Data.SqlServer as a Cake Tool
#tool nuget:?package=SujaySarma.Data.SqlServer&version=9.1.0

Sujay Sarma's SQL Server Client SDK

(SQL Server, SQL Express, LocalDB, SQL Azure, SQL Server on Linux compatible)

Library Current version
SujaySarma.Data.SqlServer Version 9.1.0

NuGet Package

https://www.nuget.org/packages/SujaySarma.Data.SqlServer

Source code

https://github.com/sujayvsarma/SujaySarma.Data/tree/master/SujaySarma.Data.SqlServer

Changelog

Version Changes
9.1.0 Dependency packages updates
9.0.0 Revamped dependency system with SujaySarma.Data.Core
8.9.7 Addresses security vulnerability in Microsoft.Data.SqlClient
8.9.6 Adds support for .NET 6.0+
8.9.0 Bug fixes, Adds Enable|DisableDebugging()
8.8.5 Bug fixes, chain Join/Where/OrderBy statements, removes need for qb.Select<T>()
8.8.0 Fluid builders, support for Lambda expressions
8.7.5 Nullability bug fix in ExecuteScalarAsync().
8.7.0 SQL Injection mitigation for Select() methods.
8.5.0 Added UpsertAsync() and SQLTABLECONTEXT_DUMPSQL env variable support.
8.2.0 New method ExecuteStoredProcedure. Other performance improvements and bug fixes.
8.0.0 Initial version.

See Change log for more details.

About this library

This library simplifies writing data storage and retrieval code against databases hosted on Microsoft SQL Server technologies. You no longer need to use cumbersome frameworks like EntityFramework (EF) to simplify or automate your database interaction and ORM process.

This library is built on the same lines as my popular Azure Tables Client SDK and offers a highly simplified and super-performant structure.

Dependencies

This package depends on the 'Microsoft.Data.SqlClient' library. And uses 'System.Data' and 'System.Reflection' extensively.

Dependability and Trustworthiness

  • The codebase is mostly the same as used in the 'Azure Tables Client SDK' (see link above).
  • Given that the Azure Tables Client SDK is heavily performance optimized, all the same learnings have been directly applied here.
  • Source code is available for your perusal on the GitHub page linked.

Usage

For usage instructions, please refer to this document Happy coding!

Product Compatible and additional computed target framework versions.
.NET 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. 
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
9.1.0 103 6/26/2024
8.9.7 122 2/15/2024
8.9.0 157 12/2/2023
8.8.5 137 11/30/2023
8.8.0 198 7/28/2023
8.7.5 165 6/27/2023
8.7.0 156 5/19/2023
8.2.0 202 3/28/2023
8.0.0 242 2/20/2023

v 9.1.0  - Revamped release
v 8.9.7  - Addresses security vulnerability in Microsoft.Data.SqlClient by updating to the latest version.
v 8.9.6  - Adds support for .NET 6.0+
v 8.9.0  - Some enhancements and bug fixes
v 8.8.5   - Bug fixes, small performance enhancements
v 8.8.0   - New fluid-style query builders, support for lambda expressions
v 8.7.5   - Null bug fix in ExecuteScalarAsync.
v 8.7.0  - SQL Injection mitigation for various SELECT methods.
v 8.5.0  - Adds MERGE statement support, debug flag "SQLTABLECONTEXT_DUMPSQL".
v 8.2.0   - Adds Stored Procedure execution, performance improvements, bug fixes.
v 8.0.0   - This is the initial version of the SQL Server client operations package.