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. 
#:package Dapper@2.1.66
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=Dapper&version=2.1.66
                    


                            Install as a Cake Addin
                        

                    

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


                            Install 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.5K)

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

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.
Sonarr/Sonarr
Smart PVR for newsgroup and bittorrent users.
Radarr/Radarr
Movie organizer/manager for usenet and torrent users.
aspnetboilerplate/aspnetboilerplate
ASP.NET Boilerplate - Web Application Framework
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
btcpayserver/btcpayserver
Accept Bitcoin payments. Free, open-source & self-hosted, Bitcoin payment processor.
dotnetcore/CAP
Distributed transaction solution in micro-service base on eventually consistency, also an eventbus with Outbox pattern
Uahh/ToastFish
一个利用摸鱼时间背单词的软件。
DotNetNext/SqlSugar
.Net aot ORM SqlServer ORM Mongodb ORM MySql 瀚高 Postgresql ORM DB2 Hana 高斯 Duckdb C# VB.NET Sqlite ORM Oracle ORM Mysql Orm 虚谷数据库 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET9 ORM .NET8 ORM ClickHouse ORM QuestDb ,TDengine ORM,OceanBase ORM,GaussDB ORM,Tidb ORM Object/Relational Mapping
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.
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.
dotnet/aspire
Tools, templates, and packages to accelerate building observable, production-ready apps
dotnetcore/Util
Util是一个.Net平台下的应用框架，旨在提升中小团队的开发能力，由工具类、分层架构基类、Ui组件，配套代码生成模板，权限等组成。
Lidarr/Lidarr
Looks and smells like Sonarr but made for music.
opserver/Opserver
Stack Exchange's Monitoring System
Version Downloads Last Updated
2.1.66 21,244,971 2/6/2025
2.1.35 50,332,571 3/6/2024
2.1.28 12,742,643 1/2/2024
2.1.24 6,725,698 11/23/2023
2.1.21 2,529,000 11/11/2023
2.1.15 3,423,011 10/19/2023
2.1.11 1,990,477 10/13/2023
2.1.4 2,056,531 9/13/2023
2.0.151 6,784,730 8/18/2023
2.0.143 8,677,608 6/20/2023
2.0.138 1,025,535 6/9/2023
2.0.123 124,261,978 11/3/2021
2.0.90 31,927,620 4/29/2021
2.0.78 51,278,448 11/18/2020
2.0.35 45,188,270 4/5/2020
2.0.30 34,518,672 9/27/2019
2.0.4 4,353,900 8/29/2019
1.60.6 24,286,514 3/30/2019
1.60.5 180,962 3/27/2019
1.60.1 6,078,838 3/3/2019
1.50.5 37,784,496 5/18/2018
1.50.4 11,845,230 11/26/2017
1.50.4-alpha1-00070 121,903 9/14/2017
1.50.2 20,779,527 7/22/2016
1.50.1 4,408,148 7/8/2016
1.50.0 1,146,518 7/1/2016
1.50.0-rc3 34,266 6/28/2016
1.50.0-rc2b 21,183 6/8/2016
1.50.0-rc2a 16,297 5/27/2016
1.50.0-rc2 27,961 5/19/2016
1.50.0-beta9 47,329 4/1/2016
1.50.0-beta8 29,034 2/17/2016
1.50.0-beta7 20,855 1/5/2016
1.50.0-beta6 13,458 12/19/2015
1.50.0-beta5 13,365 12/8/2015
1.50.0-beta4 16,612 11/26/2015
1.50.0-beta3 12,411 11/19/2015
1.50.0-beta2 11,277 11/19/2015
1.50.0-beta1 13,773 11/3/2015
1.42.0 5,956,455 5/6/2015
1.41.0-beta5 21,997 5/6/2015
1.41.0-beta4 11,162 5/5/2015
1.41.0-beta3 11,598 5/2/2015
1.41.0-beta2 11,206 5/1/2015
1.41.0-beta 11,394 5/1/2015
1.41.0-alpha 11,801 4/29/2015
1.40.0 813,652 4/3/2015
1.39.0 134,492 3/18/2015
1.38.0 1,547,948 10/30/2014
1.37.0 148,206 10/22/2014
1.36.0 79,963 10/14/2014
1.35.0 174,023 9/29/2014
1.34.0 205,803 8/28/2014
1.33.0 13,346 8/28/2014
1.32.0 47,023 8/28/2014
1.31.0 19,571 8/26/2014
1.30.0 65,590 8/14/2014
1.29.0 85,124 8/6/2014
1.27.0 99,783 7/14/2014
1.26.0 51,845 7/3/2014
1.25.0 235,756 5/14/2014
1.24.0 13,040 5/14/2014
1.23.0 22,000 5/12/2014
1.22.0 18,377 5/8/2014
1.21.0 12,485 5/8/2014
1.20.0 17,195 5/8/2014
1.13.0 955,248 5/24/2013
1.12.1 360,674 9/19/2012
1.12.0 706,783 9/19/2012
1.11.0 20,732 9/4/2012
1.10.0 33,608 6/27/2012
1.9.0 22,730 6/12/2012
1.8.0 111,059 1/12/2012
1.7.0 47,590 11/5/2011
1.6.0 30,168 11/5/2011
1.5.0 30,728 7/13/2011
1.4.0 27,793 6/14/2011
1.3.0 25,805 5/23/2011
1.2.0 29,901 5/16/2011
1.1.0 18,011 4/26/2011
1.0.0 416,415 4/14/2011

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