EssentialLayers.Dapper
1.4.1
dotnet add package EssentialLayers.Dapper --version 1.4.1
NuGet\Install-Package EssentialLayers.Dapper -Version 1.4.1
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="EssentialLayers.Dapper" Version="1.4.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="EssentialLayers.Dapper" Version="1.4.1" />
<PackageReference Include="EssentialLayers.Dapper" />
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 EssentialLayers.Dapper --version 1.4.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EssentialLayers.Dapper, 1.4.1"
#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 EssentialLayers.Dapper@1.4.1
#: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=EssentialLayers.Dapper&version=1.4.1
#tool nuget:?package=EssentialLayers.Dapper&version=1.4.1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Essential Layers
EssentialLayers.Dapper
Is a complement to the package EssentialLayers to provide an extra layer with the ORM dapper, where the main purpose will be, write the business logic in the "stored procedures" using templates that receiving input parameters and return a result set, Currently is just compatible with SQL Server.
Configure
Add the dependencies in your Program.cs file
builder.Services.Configure<ConnectionOption>(
options =>
{
options.ConnectionString = builder.Configuration.GetConnectionString("Local")!;
}
);
builder.Services.UseDapper();
Release Notes
- fix: IEnumerable<T> and T are considered as a datatable parameter and static cache has been changed by extension method
05/03/2026 - refactor: apply SRP by splitting DapperExtension and ConnectionHelper into focused classes
05/03/2026 - refactor: eliminate duplicated connection pattern via DbExecutor and BaseProcedureHelper (DRY)
05/03/2026 - perf: add reflection cache, fix connection pooling, pure async reader, and ArrayPool for SqlParameter
05/03/2026 - refactor: introduce IDbConnectionFactory to invert connection dependency (DIP)
05/03/2026 - fix: Now are included primitives, objects and enumarables as a UDT parameters in Complex Procedures (tested)
04/03/2026 - refactor: Fixing method naming
04/03/2026 - fix: Now are included primitives, objects and enumarables as a UDT parameters in Complex Procedures
04/03/2026 - refactor: Implementation of own helper to decoupling the procedure helper
04/03/2026 - fix: Type specification on add column in the Datatable when use ComplexProcedure interface (Reported by user implementation on try to add Datetime field)
04/03/2026 - refactor: Implementation of own service to decoupling the procedure service
04/03/2026 - The IConnectionString service was removed to allowing the developer configure options, before to call UseDapper function
28/01/2026 - Segregation of dependecy IProcedureService in IComplexProcedure, INormalProcedure and IMultipleProcedure
28/01/2026 - Refactor Dapper helpers for DI and connection validation
19/01/2026 - Health check implementation and updating of dependencies to the last version
21/10/2025 - Added SetConnection to set the runtime value
24/01/2025
Created by Mario Soto Moreno
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. 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 was computed. 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. net9.0 was computed. 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. |
| .NET Core | netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.1 is compatible. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETStandard 2.1
- Dapper (>= 2.1.66)
- EssentialLayers (>= 1.6.6)
- Microsoft.Data.SqlClient (>= 6.1.4)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
- fix: IEnumerable<T> and T are considered as a datatable parameter and static cache has been changed by extension method `05/03/2026`
- refactor: apply SRP by splitting DapperExtension and ConnectionHelper into focused classes `05/03/2026`
- refactor: eliminate duplicated connection pattern via DbExecutor and BaseProcedureHelper (DRY) `05/03/2026`
- perf: add reflection cache, fix connection pooling, pure async reader, and ArrayPool for SqlParameter `05/03/2026`
- refactor: introduce IDbConnectionFactory to invert connection dependency (DIP) `05/03/2026`