DapperAddons 1.0.2

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

// Install DapperAddons as a Cake Tool
#tool nuget:?package=DapperAddons&version=1.0.2

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 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. 
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
1.0.2 453 6/21/2022
1.0.1 461 6/14/2022
1.0.0 420 6/14/2022

A new Populate Dropdown method has been added