DKX.Pg
2.0.0-alpha.4
Prefix Reserved
.NET 5.0
This package targets .NET 5.0. The package is compatible with this framework or higher.
.NET Core 3.1
This package targets .NET Core 3.1. The package is compatible with this framework or higher.
This is a prerelease version of DKX.Pg.
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package DKX.Pg --version 2.0.0-alpha.4
NuGet\Install-Package DKX.Pg -Version 2.0.0-alpha.4
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="DKX.Pg" Version="2.0.0-alpha.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DKX.Pg --version 2.0.0-alpha.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DKX.Pg, 2.0.0-alpha.4"
#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.
// Install DKX.Pg as a Cake Addin #addin nuget:?package=DKX.Pg&version=2.0.0-alpha.4&prerelease // Install DKX.Pg as a Cake Tool #tool nuget:?package=DKX.Pg&version=2.0.0-alpha.4&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
DKX/Pg
PostgreSQL only client with something better than query builder or LINQ (hint: pure SQL is better)
- PostgreSQL only
- Async only
- Mapping to immutable classes via constructor
- Opening connection automatically when needed
- Automatic nested transactions (with savepoints)
- Plain SQL with snippets
- Convention over configuration
Installation
$ dotnet add package DKX.Pg
Example
using DKX.Pg;
await using var db = new Connection(new NpgsqlConnection(connectionString));
var email = "john@doe.com";
var query = db.Query($"SELECT id, email FROM users WHERE email = {email}"); // <- No worry, that is not "SQL injection ready" query, read more ;-)
// SQL: SELECT id, email FROM users WHERE email = @p0
var user = await query.GetSingleResult<User>();
Documentation
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 is compatible. 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 was computed. 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. |
| .NET Core | netcoreapp3.1 is compatible. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last updated | |
|---|---|---|---|
| 2.11.0 | 6,045 | 5/2/2022 | |
| 2.10.0 | 484 | 5/2/2022 | |
| 2.9.0 | 588 | 4/24/2022 | |
| 2.8.0 | 489 | 4/23/2022 | |
| 2.7.1 | 477 | 4/23/2022 | |
| 2.7.0 | 492 | 4/23/2022 | |
| 2.6.0 | 486 | 4/23/2022 | |
| 2.5.0 | 484 | 4/22/2022 | |
| 2.4.1 | 1,228 | 2/25/2022 | |
| 2.4.0 | 507 | 2/25/2022 | |
| 2.3.0 | 1,046 | 12/15/2021 | |
| 2.2.0 | 377 | 12/15/2021 | |
| 2.1.0 | 3,077 | 11/25/2021 | |
| 2.0.1 | 973 | 9/15/2021 | |
| 2.0.0 | 515 | 9/12/2021 | |
| 2.0.0-alpha.14 | 249 | 9/11/2021 | |
| 2.0.0-alpha.13 | 223 | 9/11/2021 | |
| 2.0.0-alpha.12 | 552 | 8/10/2021 | |
| 2.0.0-alpha.11 | 197 | 8/10/2021 | |
| 2.0.0-alpha.10 | 211 | 8/10/2021 | |
| 2.0.0-alpha.9 | 195 | 8/9/2021 | |
| 2.0.0-alpha.8 | 175 | 8/6/2021 | |
| 2.0.0-alpha.7 | 194 | 8/6/2021 | |
| 2.0.0-alpha.6 | 188 | 8/6/2021 | |
| 2.0.0-alpha.5 | 203 | 8/6/2021 | |
| 2.0.0-alpha.4 | 216 | 8/6/2021 | |
| 2.0.0-alpha.3 | 224 | 8/6/2021 | |
| 2.0.0-alpha.2 | 192 | 8/6/2021 | |
| 2.0.0-alpha.1 | 190 | 8/6/2021 | |
| 1.2.0 | 1,224 | 5/29/2021 | |
| 1.1.0 | 514 | 5/16/2021 | |
| 1.0.1 | 413 | 5/16/2021 | |
| 1.0.0 | 455 | 5/16/2021 | |
| 0.0.1-alpha.14 | 342 | 4/17/2021 | |
| 0.0.1-alpha.13 | 247 | 4/11/2021 | |
| 0.0.1-alpha.12 | 213 | 4/10/2021 | |
| 0.0.1-alpha.11 | 478 | 3/5/2021 | |
| 0.0.1-alpha.10 | 213 | 2/25/2021 | |
| 0.0.1-alpha.9 | 216 | 2/25/2021 | |
| 0.0.1-alpha.8 | 226 | 2/25/2021 | |
| 0.0.1-alpha.7 | 229 | 2/24/2021 | |
| 0.0.1-alpha.6 | 199 | 2/23/2021 | |
| 0.0.1-alpha.5 | 200 | 2/22/2021 | |
| 0.0.1-alpha.4 | 185 | 2/17/2021 | |
| 0.0.1-alpha.3 | 188 | 2/17/2021 | |
| 0.0.1-alpha.2 | 182 | 2/16/2021 | |
| 0.0.1-alpha.1 | 176 | 2/16/2021 |