SQLStoredProcedureCommandsFunctions 1.0.0.8

There is a newer version of this package available.
See the version list below for details.

dotnet add package SQLStoredProcedureCommandsFunctions --version 1.0.0.8

NuGet\Install-Package SQLStoredProcedureCommandsFunctions -Version 1.0.0.8

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="SQLStoredProcedureCommandsFunctions" Version="1.0.0.8" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="SQLStoredProcedureCommandsFunctions" Version="1.0.0.8" />
                    

                            Directory.Packages.props

<PackageReference Include="SQLStoredProcedureCommandsFunctions" />
                    

                            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 SQLStoredProcedureCommandsFunctions --version 1.0.0.8

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: SQLStoredProcedureCommandsFunctions, 1.0.0.8"

#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 SQLStoredProcedureCommandsFunctions@1.0.0.8

#: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=SQLStoredProcedureCommandsFunctions&version=1.0.0.8
                    

                            Install as a Cake Addin

#tool nuget:?package=SQLStoredProcedureCommandsFunctions&version=1.0.0.8
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

SQLStoredProcedureCommandsFunctions 1.0.0.8

A lightweight yet powerful SQL Server data-access library that simplifies working with stored procedures, DataTables, SQL parameters, and Azure SQL authentication.
Built for .NET 10 enterprise applications requiring clean, reusable, and high-performance database access.

🚀 Features

✔ Azure SQL Authentication (Managed Identity Ready)

Environment-aware token generation
Local: VisualStudioCredential
Cloud: DefaultAzureCredential
Automatic AccessToken injection into SqlConnection
Zero code changes required when deploying to Azure

✔ Full Data Access Layer (DAL)

Rich APIs for executing SQL commands:

ExecuteNonQuery
ExecuteScalar
ExecuteDataset
ExecuteReader
ExecuteXmlReader

Supports:

sync & async programming
Connection string, SqlConnection, or SqlTransaction
Stored procedures or raw SQL
Automatic command preparation

✔ Stored Procedure Parameter Caching

Automatically discovers stored procedure parameters
Caches them using synchronized hashtable
Fast repeated execution
Eliminates DeriveParameters overhead

✔ SQL Parameter Utilities

Convert C# classes → SqlParameter list
[IgnoreDBParameter] attribute to skip properties
Automatic SqlDbType inference
Create strongly typed parameters easily

✔ Data Conversion Helpers

DataTable → List<T> / IEnumerable<T>
List<T> / IEnumerable<T> → DataTable
DataSet / DataTable → Dictionary
Column reordering & shifting utilities

✔ Legacy-style SqlHelper (Optional)

Transaction support
Bulk SP execution
Dataset update utilities

📦 Installation

Install from NuGet:

dotnet add package SQLStoredProcedureCommandsFunctions --version 1.0.0.8

Product	Compatible and additional computed target framework versions.
.NET	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.

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net10.0
- Microsoft.Data.SqlClient (>= 6.1.3)
- Microsoft.Extensions.Configuration (>= 10.0.0)

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
1.0.1	77	12/16/2025
1.0.0.9	73	12/16/2025
1.0.0.8	669	12/3/2025
1.0.0.7	647	12/3/2025
1.0.0.6	2,007	11/20/2025
1.0.0.4	1,769	7/4/2025
1.0.0.3	221	10/10/2024
1.0.0.2	556	10/13/2023
1.0.0.1	541	10/13/2023

Release Notes - v1.0.0.8

Release Notes - v1.0.0.8

🚀 Key Features
🔹 1. Azure SQL Authentication

Added AzureCredential helper with environment-aware token resolution.

Supports:

Local development via VisualStudioCredential

Cloud environments via DefaultAzureCredential

Automatic access token generation for SQL connections.
(Files: AzureCredential.cs)

🔹 2. Complete Data Access Layer (DAL)

Rich set of methods for executing:

ExecuteNonQuery

ExecuteScalar

ExecuteDataset

ExecuteReader

ExecuteXmlReader

Full support for:

Connection strings

Existing SqlConnection

SqlTransaction

Stored procedure parameter mapping

Async/await methods

Built-in Azure token injection for SQL connections
(File: DataAccessLayer.cs)

🔹 3. Stored Procedure Parameter Caching

Adds performance optimization via SqlHelperParameterCache

Automatically discovers SP parameters using DeriveParameters

Thread-safe caching using synchronized Hashtable

Reduces database metadata lookups
(File: SqlHelperParameterCache.cs)

🔹 4. Data Conversion Utilities

Convert DataTable or DataSet to:

List<T>

IEnumerable<T>

Dictionary<string, object>

Convert Lists and Enumerables to DataTables
(File: DataAccessConverter.cs)

🔹 5. DataTable Extensions

Move columns to specific indices

Retrieve column lists from given index

Support for re-ordering data structures
(File: DataTableExtensions.cs)

🔹 6. SQL Parameter Helpers

Generate SQL parameters from model objects

Supports [IgnoreDbParameter] attribute to skip fields

Auto-map CLR types to SqlDbType

Utility for strongly typed one-off parameters
(Files: SQLParamHelper.cs, IgnoreDbParameter.cs)

🔹 7. Legacy-Style SqlHelper (Optional Utilities)

Transaction support

Bulk execution helpers

Dataset update helpers
(File: SqlHelper.cs)

⚙️ Improvements Over Traditional ADO.NET Approach

Less boilerplate – simplified stored procedure execution

Built-in Azure AD token-based authentication

Strong separation of concerns and reusability

Centralized parameter caching for increased performance

Async support across all major operations

🧪 Tested Scenarios

Executing stored procedures with and without parameters

Transactions with rollback and commit

Azure SQL authentication both locally and in cloud

Automatic reflection-based type conversion

DataTable/Enumerable/List conversion utilities

📘 Target Framework

.NET 8.0 (Fully compatible with .NET 6+)