Dapper 2.1.66

Prefix Reserved
.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. .NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.6.1 This package targets .NET Framework 4.6.1. The package is compatible with this framework or higher. 
dotnet add package Dapper --version 2.1.66                

                    
                

            
NuGet\Install-Package Dapper -Version 2.1.66
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.66" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add Dapper --version 2.1.66                

                    
                

            
#r "nuget: Dapper, 2.1.66"
#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.66

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

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.

Sponsors

Dapper was originally developed for and by Stack Overflow, but is F/OSS. Sponsorship is welcome and invited - see the sponsor link at the top of the page. A huge thanks to everyone (individuals or organisations) who have sponsored Dapper, but a massive thanks in particular to:

Dapper Plus logo

Product 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 is compatible.  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. 
.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.3K)

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 (271)

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.66 1,289,631 2/6/2025
2.1.35 30,270,559 3/6/2024
2.1.28 9,913,677 1/2/2024
2.1.24 5,103,612 11/23/2023
2.1.21 2,078,912 11/11/2023
2.1.15 2,898,136 10/19/2023
2.1.11 1,407,358 10/13/2023
2.1.4 1,698,968 9/13/2023
2.0.151 5,618,156 8/18/2023
2.0.143 7,629,553 6/20/2023
2.0.138 905,178 6/9/2023
2.0.123 106,624,338 11/3/2021
2.0.90 28,863,092 4/29/2021
2.0.78 44,636,131 11/18/2020
2.0.35 41,605,866 4/5/2020
2.0.30 31,948,219 9/27/2019
2.0.4 4,019,681 8/29/2019
1.60.6 22,437,481 3/30/2019
1.60.5 168,976 3/27/2019
1.60.1 5,627,036 3/3/2019
1.50.5 35,244,954 5/18/2018
1.50.4 11,005,458 11/26/2017
1.50.4-alpha1-00070 116,258 9/14/2017
1.50.2 19,501,970 7/22/2016
1.50.1 4,274,186 7/8/2016
1.50.0 1,063,170 7/1/2016
1.50.0-rc3 33,366 6/28/2016
1.50.0-rc2b 20,248 6/8/2016
1.50.0-rc2a 15,719 5/27/2016
1.50.0-rc2 27,069 5/19/2016
1.50.0-beta9 45,119 4/1/2016
1.50.0-beta8 28,592 2/17/2016
1.50.0-beta7 20,399 1/5/2016
1.50.0-beta6 13,119 12/19/2015
1.50.0-beta5 12,989 12/8/2015
1.50.0-beta4 16,220 11/26/2015
1.50.0-beta3 12,060 11/19/2015
1.50.0-beta2 10,933 11/19/2015
1.50.0-beta1 13,255 11/3/2015
1.42.0 5,511,032 5/6/2015
1.41.0-beta5 20,029 5/6/2015
1.41.0-beta4 10,811 5/5/2015
1.41.0-beta3 11,232 5/2/2015
1.41.0-beta2 10,855 5/1/2015
1.41.0-beta 10,967 5/1/2015
1.41.0-alpha 11,343 4/29/2015
1.40.0 768,129 4/3/2015
1.39.0 129,172 3/18/2015
1.38.0 1,484,162 10/30/2014
1.37.0 145,800 10/22/2014
1.36.0 76,898 10/14/2014
1.35.0 163,950 9/29/2014
1.34.0 199,930 8/28/2014
1.33.0 12,776 8/28/2014
1.32.0 44,594 8/28/2014
1.31.0 18,940 8/26/2014
1.30.0 63,244 8/14/2014
1.29.0 82,230 8/6/2014
1.27.0 96,909 7/14/2014
1.26.0 50,762 7/3/2014
1.25.0 231,065 5/14/2014
1.24.0 12,549 5/14/2014
1.23.0 21,510 5/12/2014
1.22.0 17,807 5/8/2014
1.21.0 12,014 5/8/2014
1.20.0 16,281 5/8/2014
1.13.0 894,220 5/24/2013
1.12.1 339,170 9/19/2012
1.12.0 640,039 9/19/2012
1.11.0 19,502 9/4/2012
1.10.0 31,615 6/27/2012
1.9.0 22,192 6/12/2012
1.8.0 103,478 1/12/2012
1.7.0 46,977 11/5/2011
1.6.0 29,574 11/5/2011
1.5.0 30,083 7/13/2011
1.4.0 27,197 6/14/2011
1.3.0 25,240 5/23/2011
1.2.0 28,345 5/16/2011
1.1.0 17,432 4/26/2011
1.0.0 299,724 4/14/2011

https://dapperlib.github.io/Dapper/