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. 
<PackageVersion Include="Dapper" Version="2.1.66" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Dapper" />
                    


                            Project file
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 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. 
#addin nuget:?package=Dapper&version=2.1.66
                    


                            Install Dapper as a Cake Addin
                        

                    

                
#tool nuget:?package=Dapper&version=2.1.66
                    


                            Install Dapper as a Cake Tool

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.  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 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.4K)

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

Showing the top 20 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
kgrzybek/modular-monolith-with-ddd
Full Modular Monolith application with Domain-Driven Design approach.
aspnetboilerplate/aspnetboilerplate
ASP.NET Boilerplate - Web Application Framework
Sonarr/Sonarr
Smart PVR for newsgroup and bittorrent users.
Radarr/Radarr
Movie organizer/manager for usenet and torrent users.
HangfireIO/Hangfire
An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
MassTransit/MassTransit
Distributed Application Framework for .NET
elsa-workflows/elsa-core
A .NET workflows library
dotnetcore/CAP
Distributed transaction solution in micro-service base on eventually consistency, also an eventbus with Outbox pattern
btcpayserver/btcpayserver
Accept Bitcoin payments. Free, open-source & self-hosted, Bitcoin payment processor.
Uahh/ToastFish
一个利用摸鱼时间背单词的软件。
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM DB2 Hana Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
dotnet/tye
Tye is a tool that makes developing, testing, and deploying microservices and distributed applications easier. Project Tye includes a local orchestrator to make developing microservices easier and the ability to deploy microservices to Kubernetes with minimal configuration.
1Remote/1Remote
One Remote Access Manager to Rule Them All
Prowlarr/Prowlarr
Prowlarr is an indexer manager/proxy built on the popular *arr .net/reactjs base stack to integrate with your various PVR apps, supporting management of both Torrent Trackers and Usenet Indexers.
dotnetcore/Util
Util是一个.Net平台下的应用框架，旨在提升中小团队的开发能力，由工具类、分层架构基类、Ui组件，配套代码生成模板，权限等组成。
dotnet/aspire
Tools, templates, and packages to accelerate building observable, production-ready apps
opserver/Opserver
Stack Exchange's Monitoring System
Version Downloads Last updated
2.1.66 8,771,022 2/6/2025
2.1.35 39,279,586 3/6/2024
2.1.28 11,149,931 1/2/2024
2.1.24 5,798,371 11/23/2023
2.1.21 2,280,296 11/11/2023
2.1.15 3,127,738 10/19/2023
2.1.11 1,713,688 10/13/2023
2.1.4 1,863,852 9/13/2023
2.0.151 6,146,819 8/18/2023
2.0.143 8,106,564 6/20/2023
2.0.138 959,644 6/9/2023
2.0.123 114,025,677 11/3/2021
2.0.90 30,157,719 4/29/2021
2.0.78 47,359,076 11/18/2020
2.0.35 43,088,490 4/5/2020
2.0.30 33,044,806 9/27/2019
2.0.4 4,137,708 8/29/2019
1.60.6 23,267,756 3/30/2019
1.60.5 174,115 3/27/2019
1.60.1 5,817,714 3/3/2019
1.50.5 36,295,451 5/18/2018
1.50.4 11,369,609 11/26/2017
1.50.4-alpha1-00070 118,763 9/14/2017
1.50.2 20,038,103 7/22/2016
1.50.1 4,329,581 7/8/2016
1.50.0 1,102,091 7/1/2016
1.50.0-rc3 33,549 6/28/2016
1.50.0-rc2b 20,532 6/8/2016
1.50.0-rc2a 15,905 5/27/2016
1.50.0-rc2 27,284 5/19/2016
1.50.0-beta9 46,049 4/1/2016
1.50.0-beta8 28,736 2/17/2016
1.50.0-beta7 20,553 1/5/2016
1.50.0-beta6 13,225 12/19/2015
1.50.0-beta5 13,117 12/8/2015
1.50.0-beta4 16,347 11/26/2015
1.50.0-beta3 12,175 11/19/2015
1.50.0-beta2 11,055 11/19/2015
1.50.0-beta1 13,429 11/3/2015
1.42.0 5,703,034 5/6/2015
1.41.0-beta5 20,955 5/6/2015
1.41.0-beta4 10,919 5/5/2015
1.41.0-beta3 11,351 5/2/2015
1.41.0-beta2 10,974 5/1/2015
1.41.0-beta 11,112 5/1/2015
1.41.0-alpha 11,509 4/29/2015
1.40.0 788,560 4/3/2015
1.39.0 131,864 3/18/2015
1.38.0 1,512,492 10/30/2014
1.37.0 146,688 10/22/2014
1.36.0 78,009 10/14/2014
1.35.0 168,116 9/29/2014
1.34.0 202,641 8/28/2014
1.33.0 13,017 8/28/2014
1.32.0 45,604 8/28/2014
1.31.0 19,208 8/26/2014
1.30.0 64,438 8/14/2014
1.29.0 83,836 8/6/2014
1.27.0 97,967 7/14/2014
1.26.0 51,294 7/3/2014
1.25.0 233,181 5/14/2014
1.24.0 12,759 5/14/2014
1.23.0 21,735 5/12/2014
1.22.0 18,044 5/8/2014
1.21.0 12,226 5/8/2014
1.20.0 16,613 5/8/2014
1.13.0 916,310 5/24/2013
1.12.1 348,400 9/19/2012
1.12.0 667,126 9/19/2012
1.11.0 20,013 9/4/2012
1.10.0 32,641 6/27/2012
1.9.0 22,342 6/12/2012
1.8.0 106,727 1/12/2012
1.7.0 47,139 11/5/2011
1.6.0 29,747 11/5/2011
1.5.0 30,270 7/13/2011
1.4.0 27,334 6/14/2011
1.3.0 25,419 5/23/2011
1.2.0 28,836 5/16/2011
1.1.0 17,675 4/26/2011
1.0.0 361,013 4/14/2011

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