Dapper 1.39.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.39.0
dotnet add package Dapper --version 1.39.0
<PackageReference Include="Dapper" Version="1.39.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Dapper --version 1.39.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

* 1.39    - fix case on SQL CLR types; grid-reader should respect no-cache flags; make parameter inclusion case-insensitive
     * 1.38    - specify constructor explicitly; allow value-type parameters (albeit: boxed)
     * 1.37    - Reuse StringBuilder instances when possible (list parameters in particular)
     * 1.36    - Fix Issue 192 (expanded parameter naming glitch) and Issue 178 (execute reader now wraps the command/reader pair, to extend the command lifetime;
     *           note that the underlying command/reader are available by casting to IWrappedDataReader)
     * 1.35    - Fix Issue 151 (Execute should work with ExpandoObject etc); Fix Issue 182 (better support for db-type when using `object` values);
     *           output expressions / callbacks in dynamic args (via Derek); arbitrary number of types in multi-mapping (via James Holwell);
     *           fix DbString/Oracle bug (via Mauro Cerutti); new support for **named positional arguments**
     * 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.

GitHub repositories (127+)

Showing the top 5 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
HangfireIO/Hangfire
An easy way to perform background job processing in your .NET and .NET Core applications. No Windows Service or separate process required

Version History

Version Downloads Last updated
2.0.35 1,298,088 4/5/2020
2.0.30 5,259,840 9/27/2019
2.0.4 1,052,669 8/29/2019
1.60.6 5,845,551 3/30/2019
1.60.5 57,547 3/27/2019
1.60.1 1,655,940 3/3/2019
1.50.5 11,133,548 5/18/2018
1.50.4 4,401,898 11/26/2017
1.50.4-alpha1-00070 70,221 9/14/2017
1.50.2 7,659,440 7/22/2016
1.50.1 2,540,182 7/8/2016
1.50.0 444,102 7/1/2016
1.50.0-rc3 16,946 6/28/2016
1.50.0-rc2b 13,504 6/8/2016
1.50.0-rc2a 10,494 5/27/2016
1.50.0-rc2 11,577 5/19/2016
1.50.0-beta9 25,960 4/1/2016
1.50.0-beta8 21,964 2/17/2016
1.50.0-beta7 14,862 1/5/2016
1.50.0-beta6 9,317 12/19/2015
1.50.0-beta5 9,076 12/8/2015
1.50.0-beta4 12,068 11/26/2015
1.50.0-beta3 8,465 11/19/2015
1.50.0-beta2 7,392 11/19/2015
1.50.0-beta1 9,201 11/3/2015
1.42.0 2,619,531 5/6/2015
1.41.0-beta5 10,825 5/6/2015
1.41.0-beta4 7,033 5/5/2015
1.41.0-beta3 7,274 5/2/2015
1.41.0-beta2 7,038 5/1/2015
1.41.0-beta 7,100 5/1/2015
1.41.0-alpha 7,164 4/29/2015
1.40.0 324,862 4/3/2015
1.39.0 69,279 3/18/2015
1.38.0 620,097 10/30/2014
1.37.0 99,903 10/22/2014
1.36.0 34,406 10/14/2014
1.35.0 80,287 9/29/2014
1.34.0 107,349 8/28/2014
1.33.0 8,105 8/28/2014
1.32.0 12,006 8/28/2014
1.31.0 12,390 8/26/2014
1.30.0 40,029 8/14/2014
1.29.0 37,882 8/6/2014
1.27.0 61,229 7/14/2014
1.26.0 35,374 7/3/2014
1.25.0 104,506 5/14/2014
1.24.0 8,219 5/14/2014
1.23.0 16,041 5/12/2014
1.22.0 12,273 5/8/2014
1.21.0 7,673 5/8/2014
1.20.0 9,857 5/8/2014
1.13.0 416,057 5/24/2013
1.12.1 137,577 9/19/2012
1.12.0 117,740 9/19/2012
1.11.0 13,191 9/4/2012
1.10.0 20,695 6/27/2012
1.9.0 15,330 6/12/2012
1.8.0 52,308 1/12/2012
1.7.0 29,605 11/5/2011
1.6.0 12,927 11/5/2011
1.5.0 9,107 7/13/2011
1.4.0 8,890 6/14/2011
1.3.0 9,049 5/23/2011
1.2.0 8,268 5/16/2011
1.1.0 11,389 4/26/2011
1.0.0 26,433 4/14/2011
Show less