Dapper 2.1.28

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet add package Dapper --version 2.1.28                
NuGet\Install-Package Dapper -Version 2.1.28                
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="Dapper" Version="2.1.28" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Dapper --version 2.1.28                
#r "nuget: Dapper, 2.1.28"                
#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 Dapper as a Cake Addin
#addin nuget:?package=Dapper&version=2.1.28

// Install Dapper as a Cake Tool
#tool nuget:?package=Dapper&version=2.1.28                

Dapper

Dapper is a simple micro-ORM used to simplify working with ADO.NET; if you like SQL but dislike the boilerplate of ADO.NET: Dapper is for you!

As a simple example:

string region = ...
var customers = connection.Query<Customer>(
    "select * from Customers where Region = @region", // SQL
    new { region } // parameters
    ).AsList();

But all the execute/single-row/scalar/async/etc functionality you would expect: is there as extension methods on your DbConnection.

See GitHub for more information and examples.

Product Compatible and additional computed target framework versions.
.NET net5.0 is compatible.  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 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 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. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 is compatible.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  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.

NuGet packages (3.2K)

Showing the top 5 NuGet packages that depend on Dapper:

Package Downloads
Dapper.Contrib

The official collection of get, insert, update and delete helpers for Dapper.net. Also handles lists of entities and optional "dirty" tracking of interface-based entities.

Hangfire.PostgreSql

PostgreSql storage implementation for Hangfire (background job system for ASP.NET and aspnet core applications).

Dapper.SqlBuilder

The Dapper SqlBuilder component, for building SQL queries dynamically.

Dapper.FluentMap

Simple API to fluently map POCO properties to database columns when using Dapper.

SqlKata.Execution

Adds the execution capabilities for SqlKata

GitHub repositories (267)

Showing the top 5 popular GitHub repositories that depend on Dapper:

Repository Stars
bitwarden/server
Bitwarden infrastructure/backend (API, database, Docker, etc).
abpframework/abp
Open-source web application framework for ASP.NET Core! Offers an opinionated architecture to build enterprise software solutions with best practices on top of the .NET. Provides the fundamental infrastructure, cross-cutting-concern implementations, startup templates, application modules, UI themes, tooling and documentation.
dotnet/AspNetCore.Docs
Documentation for ASP.NET Core
aspnetboilerplate/aspnetboilerplate
ASP.NET Boilerplate - Web Application Framework
kgrzybek/modular-monolith-with-ddd
Full Modular Monolith application with Domain-Driven Design approach.
Version Downloads Last updated
2.1.35 15,893,149 3/6/2024
2.1.28 8,153,954 1/2/2024
2.1.24 4,134,877 11/23/2023
2.1.21 1,779,718 11/11/2023
2.1.15 2,528,631 10/19/2023
2.1.11 1,067,333 10/13/2023
2.1.4 1,435,105 9/13/2023
2.0.151 4,822,297 8/18/2023
2.0.143 6,862,282 6/20/2023
2.0.138 818,684 6/9/2023
2.0.123 96,587,935 11/3/2021
2.0.90 27,005,629 4/29/2021
2.0.78 40,923,298 11/18/2020
2.0.35 39,551,757 4/5/2020
2.0.30 30,374,274 9/27/2019
2.0.4 3,865,053 8/29/2019
1.60.6 21,423,595 3/30/2019
1.60.5 161,093 3/27/2019
1.60.1 5,318,462 3/3/2019
1.50.5 33,860,142 5/18/2018
1.50.4 10,527,442 11/26/2017
1.50.4-alpha1-00070 113,247 9/14/2017
1.50.2 18,806,619 7/22/2016
1.50.1 4,190,511 7/8/2016
1.50.0 1,003,974 7/1/2016
1.50.0-rc3 33,007 6/28/2016
1.50.0-rc2b 19,826 6/8/2016
1.50.0-rc2a 15,363 5/27/2016
1.50.0-rc2 26,717 5/19/2016
1.50.0-beta9 43,762 4/1/2016
1.50.0-beta8 28,224 2/17/2016
1.50.0-beta7 19,808 1/5/2016
1.50.0-beta6 12,844 12/19/2015
1.50.0-beta5 12,647 12/8/2015
1.50.0-beta4 15,946 11/26/2015
1.50.0-beta3 11,800 11/19/2015
1.50.0-beta2 10,684 11/19/2015
1.50.0-beta1 12,899 11/3/2015
1.42.0 5,317,153 5/6/2015
1.41.0-beta5 18,807 5/6/2015
1.41.0-beta4 10,552 5/5/2015
1.41.0-beta3 10,947 5/2/2015
1.41.0-beta2 10,578 5/1/2015
1.41.0-beta 10,664 5/1/2015
1.41.0-alpha 11,031 4/29/2015
1.40.0 741,783 4/3/2015
1.39.0 125,024 3/18/2015
1.38.0 1,436,984 10/30/2014
1.37.0 144,542 10/22/2014
1.36.0 74,104 10/14/2014
1.35.0 159,249 9/29/2014
1.34.0 196,294 8/28/2014
1.33.0 12,450 8/28/2014
1.32.0 42,247 8/28/2014
1.31.0 18,550 8/26/2014
1.30.0 61,808 8/14/2014
1.29.0 79,348 8/6/2014
1.27.0 95,507 7/14/2014
1.26.0 50,134 7/3/2014
1.25.0 228,070 5/14/2014
1.24.0 12,237 5/14/2014
1.23.0 21,195 5/12/2014
1.22.0 17,463 5/8/2014
1.21.0 11,696 5/8/2014
1.20.0 15,669 5/8/2014
1.13.0 866,689 5/24/2013
1.12.1 325,766 9/19/2012
1.12.0 598,167 9/19/2012
1.11.0 18,774 9/4/2012
1.10.0 30,531 6/27/2012
1.9.0 21,833 6/12/2012
1.8.0 97,430 1/12/2012
1.7.0 46,449 11/5/2011
1.6.0 29,176 11/5/2011
1.5.0 29,720 7/13/2011
1.4.0 26,848 6/14/2011
1.3.0 24,869 5/23/2011
1.2.0 27,800 5/16/2011
1.1.0 17,061 4/26/2011
1.0.0 228,310 4/14/2011