Dapper 1.34.0

A high performance Micro-ORM supporting Sql Server, MySQL, Sqlite, SqlCE, Firebird etc..

There is a newer version of this package available.
See the version list below for details.
Install-Package Dapper -Version 1.34.0
dotnet add package Dapper --version 1.34.0
<PackageReference Include="Dapper" Version="1.34.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Dapper --version 1.34.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

* 1.34    - Support for SqlHierarchyId (core)
     * 1.33    - Support for SqlGeometry (core) and DbGeometry (EF)
     * 1.32    - Support for SqlGeography in core library
     * 1.31    - Fix issue with error message when there is a column/type mismatch
     * 1.30    - Better async cancellation
     * 1.29    - Make underscore name matching optional (opt-in) - this can be a breaking change for some people
     * 1.28    - Much better numeric type conversion; fix for large oracle strings; map Foo_Bar to FooBar (etc); ExecuteScalar added; stability fixes
     * 1.27    - Fixes for type-handler parse; ensure type-handlers get last dibs on configuring parameters
     * 1.26    - New type handler API for extension support
     * 1.25    - Command recycling and disposing during pipelined async multi-exec; enable pipeline (via sync-over-async) for sync API
     * 1.24    - Implement pipelined async multi-exec, when flag is specified (only - requires MARS etc)
     * 1.23    - Improved support for optimize hints (@foo unknown) with list expansions
     * 1.22    - Literal support now extends to enumerable types (for "in" etc usage); move to command-flags model for "buffered" etc
     * 1.21    - Limit literals to numeric types; for enums, use value not name
     * 1.20    - Improved async support in .NET 4.5 (lots of contributions from users here, including JasonPunyon, kwaclaw, tugberkugurlu, and mgravell);
     *          Now supports literal replacement via {=foo}; new ExecuteReader method (via JJoe2); support for ICustomQueryParameter
     *          dictionary members (via Blackjacketmack); culture sensitivity (via tms); fixes for time parameters (via olegKoshmeliuk);
     *          and a range of additional tweaks, twiddles, fixes and improvements.
     * 1.13   - Added support for Table Valued Parameters as part of anonymous objects
     *        - Added support for async
     *        - Added support for sharing strategies between databases
     *        - Rewrote dynamic implementation
     * 1.12.1 - Minor deploy glitch (should now include intellisense files!)
     * 1.12   - Better automatic type-mapping (int vs long, float vs double, etc)
     *          Fixed: bug with indexer properties
     * 1.11   - Custom type-map support
     * 1.10   - Fixed: error-handling could lose original exception if reader closed
     * 1.9    - Added: better schema change detection
     *          Fixed: enum support for T in Query-of-T
     *          Added: dictionary support for parameters
     * 1.8    - Started release notes
     *          Important: Dapper is now shipping as a DLL which will work on .net 3.5 or .net 4.0,
     *          This improves the debugging experience as you no longer break into dapper when SQL fails.
     *          Added: ParameterNames on DynamicParameters

Dependencies

This package has no dependencies.

NuGet packages (1.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.
DapperExtensions
A small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system.

GitHub repositories (143)

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

Repository Stars
dotnet-architecture/eShopOnContainers
Cross-platform .NET sample microservices and container based application that runs on Linux Windows and macOS. Powered by .NET Core 3.0, Docker Containers and Azure Kubernetes Services. Supports Visual Studio, VS for Mac and CLI based environments with Docker CLI, dotnet CLI, VS Code or any other code editor.
aspnetboilerplate/aspnetboilerplate
ASP.NET Boilerplate - Web Application Framework
dotnet/AspNetCore.Docs
Documentation for ASP.NET Core
dotnet/orleans
Orleans is a cross-platform framework for building distributed applications with .NET
bitwarden/server
The core infrastructure backend (API, database, Docker, etc).

Version History

Version Downloads Last updated
2.0.35 4,515,916 4/5/2020
2.0.30 7,292,391 9/27/2019
2.0.4 1,252,619 8/29/2019
1.60.6 6,981,104 3/30/2019
1.60.5 64,610 3/27/2019
1.60.1 1,935,755 3/3/2019
1.50.5 12,502,521 5/18/2018
1.50.4 4,777,709 11/26/2017
1.50.4-alpha1-00070 73,330 9/14/2017
1.50.2 8,276,124 7/22/2016
1.50.1 2,686,203 7/8/2016
1.50.0 475,150 7/1/2016
1.50.0-rc3 17,051 6/28/2016
1.50.0-rc2b 13,595 6/8/2016
1.50.0-rc2a 10,555 5/27/2016
1.50.0-rc2 12,260 5/19/2016
1.50.0-beta9 27,060 4/1/2016
1.50.0-beta8 22,332 2/17/2016
1.50.0-beta7 15,060 1/5/2016
1.50.0-beta6 9,372 12/19/2015
1.50.0-beta5 9,185 12/8/2015
1.50.0-beta4 12,144 11/26/2015
1.50.0-beta3 8,518 11/19/2015
1.50.0-beta2 7,442 11/19/2015
1.50.0-beta1 9,260 11/3/2015
1.42.0 2,796,828 5/6/2015
1.41.0-beta5 11,100 5/6/2015
1.41.0-beta4 7,083 5/5/2015
1.41.0-beta3 7,323 5/2/2015
1.41.0-beta2 7,090 5/1/2015
1.41.0-beta 7,157 5/1/2015
1.41.0-alpha 7,222 4/29/2015
1.40.0 346,690 4/3/2015
1.39.0 73,880 3/18/2015
1.38.0 647,870 10/30/2014
1.37.0 110,291 10/22/2014
1.36.0 35,041 10/14/2014
1.35.0 87,972 9/29/2014
1.34.0 113,733 8/28/2014
1.33.0 8,178 8/28/2014
1.32.0 13,133 8/28/2014
1.31.0 12,563 8/26/2014
1.30.0 42,145 8/14/2014
1.29.0 38,662 8/6/2014
1.27.0 62,130 7/14/2014
1.26.0 37,835 7/3/2014
1.25.0 108,713 5/14/2014
1.24.0 8,279 5/14/2014
1.23.0 16,423 5/12/2014
1.22.0 12,354 5/8/2014
1.21.0 7,731 5/8/2014
1.20.0 10,049 5/8/2014
1.13.0 428,760 5/24/2013
1.12.1 144,284 9/19/2012
1.12.0 129,519 9/19/2012
1.11.0 13,277 9/4/2012
1.10.0 20,931 6/27/2012
1.9.0 15,563 6/12/2012
1.8.0 53,302 1/12/2012
1.7.0 29,899 11/5/2011
1.6.0 13,032 11/5/2011
1.5.0 9,249 7/13/2011
1.4.0 8,993 6/14/2011
1.3.0 9,196 5/23/2011
1.2.0 8,348 5/16/2011
1.1.0 11,569 4/26/2011
1.0.0 27,948 4/14/2011
Show less