Dapper 2.1.66
Prefix Reserveddotnet add package Dapper --version 2.1.66
NuGet\Install-Package Dapper -Version 2.1.66
<PackageReference Include="Dapper" Version="2.1.66" />
<PackageVersion Include="Dapper" Version="2.1.66" />
<PackageReference Include="Dapper" />
paket add Dapper --version 2.1.66
#r "nuget: Dapper, 2.1.66"
#:package Dapper@2.1.66
#addin nuget:?package=Dapper&version=2.1.66
#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 is a major sponsor and is proud to contribute to the development of Dapper (read more)
- AWS who sponsored Dapper from Oct 2023 via the .NET on AWS Open Source Software Fund
Product | Versions 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. |
-
.NETFramework 4.6.1
- Microsoft.Bcl.AsyncInterfaces (>= 9.0.1)
-
.NETStandard 2.0
- Microsoft.Bcl.AsyncInterfaces (>= 9.0.1)
- System.Reflection.Emit.Lightweight (>= 4.7.0)
-
net8.0
- No dependencies.
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 (279)
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
|
|
elsa-workflows/elsa-core
A .NET workflows library
|
|
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
|
|
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.
|
|
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/aspire
Tools, templates, and packages to accelerate building observable, production-ready apps
|
|
dotnetcore/Util
Util是一个.Net平台下的应用框架,旨在提升中小团队的开发能力,由工具类、分层架构基类、Ui组件,配套代码生成模板,权限等组成。
|
|
opserver/Opserver
Stack Exchange's Monitoring System
|
Version | Downloads | Last Updated |
---|---|---|
2.1.66 | 15,622,493 | 2/6/2025 |
2.1.35 | 45,827,604 | 3/6/2024 |
2.1.28 | 12,076,969 | 1/2/2024 |
2.1.24 | 6,353,137 | 11/23/2023 |
2.1.21 | 2,418,677 | 11/11/2023 |
2.1.15 | 3,297,842 | 10/19/2023 |
2.1.11 | 1,911,015 | 10/13/2023 |
2.1.4 | 1,972,640 | 9/13/2023 |
2.0.151 | 6,503,954 | 8/18/2023 |
2.0.143 | 8,447,025 | 6/20/2023 |
2.0.138 | 997,054 | 6/9/2023 |
2.0.123 | 119,861,992 | 11/3/2021 |
2.0.90 | 31,126,364 | 4/29/2021 |
2.0.78 | 49,601,795 | 11/18/2020 |
2.0.35 | 44,251,296 | 4/5/2020 |
2.0.30 | 33,894,945 | 9/27/2019 |
2.0.4 | 4,260,768 | 8/29/2019 |
1.60.6 | 23,844,500 | 3/30/2019 |
1.60.5 | 177,746 | 3/27/2019 |
1.60.1 | 5,969,329 | 3/3/2019 |
1.50.5 | 37,108,837 | 5/18/2018 |
1.50.4 | 11,618,541 | 11/26/2017 |
1.50.4-alpha1-00070 | 120,871 | 9/14/2017 |
1.50.2 | 20,443,301 | 7/22/2016 |
1.50.1 | 4,371,150 | 7/8/2016 |
1.50.0 | 1,127,478 | 7/1/2016 |
1.50.0-rc3 | 33,772 | 6/28/2016 |
1.50.0-rc2b | 20,864 | 6/8/2016 |
1.50.0-rc2a | 16,123 | 5/27/2016 |
1.50.0-rc2 | 27,503 | 5/19/2016 |
1.50.0-beta9 | 46,661 | 4/1/2016 |
1.50.0-beta8 | 28,881 | 2/17/2016 |
1.50.0-beta7 | 20,711 | 1/5/2016 |
1.50.0-beta6 | 13,348 | 12/19/2015 |
1.50.0-beta5 | 13,257 | 12/8/2015 |
1.50.0-beta4 | 16,475 | 11/26/2015 |
1.50.0-beta3 | 12,305 | 11/19/2015 |
1.50.0-beta2 | 11,173 | 11/19/2015 |
1.50.0-beta1 | 13,643 | 11/3/2015 |
1.42.0 | 5,826,637 | 5/6/2015 |
1.41.0-beta5 | 21,501 | 5/6/2015 |
1.41.0-beta4 | 11,051 | 5/5/2015 |
1.41.0-beta3 | 11,492 | 5/2/2015 |
1.41.0-beta2 | 11,097 | 5/1/2015 |
1.41.0-beta | 11,277 | 5/1/2015 |
1.41.0-alpha | 11,679 | 4/29/2015 |
1.40.0 | 802,982 | 4/3/2015 |
1.39.0 | 133,434 | 3/18/2015 |
1.38.0 | 1,531,578 | 10/30/2014 |
1.37.0 | 147,475 | 10/22/2014 |
1.36.0 | 79,043 | 10/14/2014 |
1.35.0 | 171,259 | 9/29/2014 |
1.34.0 | 204,528 | 8/28/2014 |
1.33.0 | 13,182 | 8/28/2014 |
1.32.0 | 46,455 | 8/28/2014 |
1.31.0 | 19,371 | 8/26/2014 |
1.30.0 | 65,030 | 8/14/2014 |
1.29.0 | 84,187 | 8/6/2014 |
1.27.0 | 98,903 | 7/14/2014 |
1.26.0 | 51,590 | 7/3/2014 |
1.25.0 | 234,691 | 5/14/2014 |
1.24.0 | 12,918 | 5/14/2014 |
1.23.0 | 21,878 | 5/12/2014 |
1.22.0 | 18,211 | 5/8/2014 |
1.21.0 | 12,365 | 5/8/2014 |
1.20.0 | 16,940 | 5/8/2014 |
1.13.0 | 935,402 | 5/24/2013 |
1.12.1 | 354,375 | 9/19/2012 |
1.12.0 | 687,560 | 9/19/2012 |
1.11.0 | 20,414 | 9/4/2012 |
1.10.0 | 33,263 | 6/27/2012 |
1.9.0 | 22,586 | 6/12/2012 |
1.8.0 | 108,998 | 1/12/2012 |
1.7.0 | 47,389 | 11/5/2011 |
1.6.0 | 29,953 | 11/5/2011 |
1.5.0 | 30,481 | 7/13/2011 |
1.4.0 | 27,509 | 6/14/2011 |
1.3.0 | 25,607 | 5/23/2011 |
1.2.0 | 29,506 | 5/16/2011 |
1.1.0 | 17,846 | 4/26/2011 |
1.0.0 | 396,195 | 4/14/2011 |