DapperAddons 1.0.1
See the version list below for details.
dotnet add package DapperAddons --version 1.0.1
NuGet\Install-Package DapperAddons -Version 1.0.1
<PackageReference Include="DapperAddons" Version="1.0.1" />
paket add DapperAddons --version 1.0.1
#r "nuget: DapperAddons, 1.0.1"
// Install DapperAddons as a Cake Addin #addin nuget:?package=DapperAddons&version=1.0.1 // Install DapperAddons as a Cake Tool #tool nuget:?package=DapperAddons&version=1.0.1
DapperAddons
Dapper is an object–relational mapping product for the Microsoft .NET platform: it provides a framework for mapping an object-oriented domain model to a traditional relational database. Its purpose is to relieve the developer from a significant portion of relational data persistence-related programming tasks
Since the Dipper package is an open source and freely available, why do I need to create this package? Well, you're right. The main purpose behind DapperAddons is to provide convincing, concise methods so that developers become more productive.
What is Dapper Addons Package? Dapper Addons is a set of helpful methods that make a developer's life easier when working with a database. Dapper Addons include methods such as GetOneAsync, GetOneByStoreProcedureAsync, GetAllAsync, GetAllByStoreProcedureAsync, InserOneAsync and InsertOneByStoreProcedureAsync, UpdateOneAsync and UpdateOneByStoreProcedureAsync, DeleteAsync and DeleteByStoreProcedureAsync to create, update, or delete records without having to worry about opening and closing sql connections, as well as object casting.
How to use Dapper Addons:
1: Inject DbHelpers to the constructor.
2: Call any method, specify your return type, specify input parameters and name of connection string.
Return type and Input parameters can be simply system or user define data type such as string, class, object or dynamic.
You have the option of using Raw SQL Query or SQL Store Procedure to get the job done. If you wish to use the stored procedure, call only those methods whose name contains the stored procedure.
Use of GetOneAsync or GetOneByStoreProcedureAsync:
Database helper method for retrieving one record from database
Use of GetAllAsync, GetAllByStoreProcedureAsync:
Database helper method to get the list of records
InserOneAsync and InsertOneByStoreProcedureAsync:
Database Helper method to insert / save a record in a database
UpdateOneAsync and UpdateOneByStoreProcedureAsync:
Database Helper method for updating a record in database
DeleteAsync and DeleteOneByStoreProcedureAsync:
Database Helper method for deleting records from database
Product | Versions 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 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. |
-
net6.0
- Dapper (>= 2.0.123)
- Microsoft.AspNetCore.Mvc.ViewFeatures (>= 2.2.0)
- Microsoft.Extensions.Configuration (>= 6.0.1)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 6.0.0)
- System.Data.SqlClient (>= 4.8.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
A new Populate Dropdown method has been added