![]() |
VOOZH | about |
dotnet add package Dapper.SqlBuilder --version 2.1.66
NuGet\Install-Package Dapper.SqlBuilder -Version 2.1.66
<PackageReference Include="Dapper.SqlBuilder" Version="2.1.66" />
<PackageVersion Include="Dapper.SqlBuilder" Version="2.1.66" />Directory.Packages.props
<PackageReference Include="Dapper.SqlBuilder" />Project file
paket add Dapper.SqlBuilder --version 2.1.66
#r "nuget: Dapper.SqlBuilder, 2.1.66"
#:package Dapper.SqlBuilder@2.1.66
#addin nuget:?package=Dapper.SqlBuilder&version=2.1.66Install as a Cake Addin
#tool nuget:?package=Dapper.SqlBuilder&version=2.1.66Install as a Cake Tool
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.
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:
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 net5.0 was computed. net5.0-windows net5.0-windows was computed. net6.0 net6.0 was computed. net6.0-android net6.0-android was computed. net6.0-ios net6.0-ios was computed. net6.0-maccatalyst net6.0-maccatalyst was computed. net6.0-macos net6.0-macos was computed. net6.0-tvos net6.0-tvos was computed. net6.0-windows net6.0-windows was computed. net7.0 net7.0 was computed. net7.0-android net7.0-android was computed. net7.0-ios net7.0-ios was computed. net7.0-maccatalyst net7.0-maccatalyst was computed. net7.0-macos net7.0-macos was computed. net7.0-tvos net7.0-tvos was computed. net7.0-windows net7.0-windows was computed. net8.0 net8.0 is compatible. net8.0-android net8.0-android was computed. net8.0-browser net8.0-browser was computed. net8.0-ios net8.0-ios was computed. net8.0-maccatalyst net8.0-maccatalyst was computed. net8.0-macos net8.0-macos was computed. net8.0-tvos net8.0-tvos was computed. net8.0-windows net8.0-windows was computed. net9.0 net9.0 was computed. net9.0-android net9.0-android was computed. net9.0-browser net9.0-browser was computed. net9.0-ios net9.0-ios was computed. net9.0-maccatalyst net9.0-maccatalyst was computed. net9.0-macos net9.0-macos was computed. net9.0-tvos net9.0-tvos was computed. net9.0-windows net9.0-windows was computed. net10.0 net10.0 was computed. net10.0-android net10.0-android was computed. net10.0-browser net10.0-browser was computed. net10.0-ios net10.0-ios was computed. net10.0-maccatalyst net10.0-maccatalyst was computed. net10.0-macos net10.0-macos was computed. net10.0-tvos net10.0-tvos was computed. net10.0-windows net10.0-windows was computed. |
| .NET Core | netcoreapp2.0 netcoreapp2.0 was computed. netcoreapp2.1 netcoreapp2.1 was computed. netcoreapp2.2 netcoreapp2.2 was computed. netcoreapp3.0 netcoreapp3.0 was computed. netcoreapp3.1 netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 netstandard2.0 is compatible. netstandard2.1 netstandard2.1 was computed. |
| .NET Framework | net461 net461 is compatible. net462 net462 was computed. net463 net463 was computed. net47 net47 was computed. net471 net471 was computed. net472 net472 was computed. net48 net48 was computed. net481 net481 was computed. |
| MonoAndroid | monoandroid monoandroid was computed. |
| MonoMac | monomac monomac was computed. |
| MonoTouch | monotouch monotouch was computed. |
| Tizen | tizen40 tizen40 was computed. tizen60 tizen60 was computed. |
| Xamarin.iOS | xamarinios xamarinios was computed. |
| Xamarin.Mac | xamarinmac xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos xamarinwatchos was computed. |
Showing the top 5 NuGet packages that depend on Dapper.SqlBuilder:
| Package | Downloads |
|---|---|
|
fion.modelerp.core
ModelErp |
|
|
Hangfire.PostgreSql.ahydrax
PostgreSQL storage implementation for Hangfire (background job system for ASP.NET applications). |
|
|
Formula.SimpleRepo
Easy repositories for .Net built on Dapper. |
|
|
Else.TheSaga.Persistance.SqlServer
A module that allows you to save the state of the saga in sqlserver --------------------- .net core Saga / ProcessManager implementation https://github.com/b-y-t-e/TheSaga |
|
|
Dapper.GraphQL
A library designed to integrate the Dapper and graphql-dotnet projects with ease-of-use in mind and performance as the primary concern. |
Showing the top 5 popular GitHub repositories that depend on Dapper.SqlBuilder:
| Repository | Stars |
|---|---|
|
joakimskoog/AnApiOfIceAndFire
An API of Ice And Fire is the world's greatest source for quantified and structured data from the universe of Ice and Fire (as well as the HBO series Game of Thrones).
|
|
|
landmarkhw/Dapper.GraphQL
A .NET Core library designed to integrate the Dapper and graphql-dotnet projects with ease-of-use in mind and performance as the primary concern.
|
|
|
DapperLib/Dapper.Contrib
Dapper community contributions - additional extensions for Dapper
|
|
|
RaythaHQ/raytha
Raytha is a powerful CMS with an easy-to-use interface and fast performance. It offers custom content types, a template engine, and various access controls. It supports multiple storage providers and an automatically generated REST API. Upgrade your development workflow with Raytha.
|
|
|
luoyunchong/dotnetcore-examples
about learning DotNetCore via examples. DotNetCore 教程、技术栈示例代码,快速简单上手教程。
|
| Version | Downloads | Last Updated |
|---|---|---|
| 2.1.66 | 3,301,430 | 2/6/2025 |
| 2.0.78 | 14,203,795 | 11/18/2020 |
| 2.0.35 | 2,354,695 | 4/5/2020 |
| 2.0.30 | 747,149 | 9/27/2019 |
| 2.0.4 | 173,282 | 8/29/2019 |
| 1.60.1 | 741,133 | 3/3/2019 |
| 1.50.5 | 714,288 | 5/18/2018 |
| 1.50.4 | 1,777,589 | 11/26/2017 |
| 1.50.4-alpha1-00070 | 2,724 | 9/14/2017 |
| 1.50.0 | 588,414 | 7/1/2016 |
| 1.50.0-rc3 | 3,157 | 6/28/2016 |
| 1.50.0-rc2 | 3,163 | 5/27/2016 |
| 1.40.1 | 12,272 | 12/5/2016 |
| 1.40.0 | 31,236 | 4/8/2015 |