DKX.Pg 2.0.0-alpha.12

Prefix Reserved
This is a prerelease version of DKX.Pg.
There is a newer version of this package available.
See the version list below for details.
dotnet add package DKX.Pg --version 2.0.0-alpha.12                
NuGet\Install-Package DKX.Pg -Version 2.0.0-alpha.12                
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.12" />                
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.12                
#r "nuget: DKX.Pg, 2.0.0-alpha.12"                
#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.12&prerelease

// Install DKX.Pg as a Cake Tool
#tool nuget:?package=DKX.Pg&version=2.0.0-alpha.12&prerelease                

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 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.
  • .NETCoreApp 3.1

  • net5.0

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 5,971 5/2/2022 2.11.0 is deprecated because it is no longer maintained.
2.10.0 482 5/2/2022 2.10.0 is deprecated because it is no longer maintained.
2.9.0 584 4/24/2022 2.9.0 is deprecated because it is no longer maintained.
2.8.0 485 4/23/2022 2.8.0 is deprecated because it is no longer maintained.
2.7.1 475 4/23/2022 2.7.1 is deprecated because it is no longer maintained.
2.7.0 490 4/23/2022 2.7.0 is deprecated because it is no longer maintained.
2.6.0 482 4/23/2022 2.6.0 is deprecated because it is no longer maintained.
2.5.0 482 4/22/2022 2.5.0 is deprecated because it is no longer maintained.
2.4.1 1,226 2/25/2022 2.4.1 is deprecated because it is no longer maintained.
2.4.0 505 2/25/2022 2.4.0 is deprecated because it is no longer maintained.
2.3.0 1,042 12/15/2021 2.3.0 is deprecated because it is no longer maintained.
2.2.0 373 12/15/2021 2.2.0 is deprecated because it is no longer maintained.
2.1.0 3,075 11/25/2021 2.1.0 is deprecated because it is no longer maintained.
2.0.1 971 9/15/2021 2.0.1 is deprecated because it is no longer maintained.
2.0.0 507 9/12/2021 2.0.0 is deprecated because it is no longer maintained.
2.0.0-alpha.14 245 9/11/2021 2.0.0-alpha.14 is deprecated because it is no longer maintained.
2.0.0-alpha.13 219 9/11/2021 2.0.0-alpha.13 is deprecated because it is no longer maintained.
2.0.0-alpha.12 550 8/10/2021 2.0.0-alpha.12 is deprecated because it is no longer maintained.
2.0.0-alpha.11 193 8/10/2021 2.0.0-alpha.11 is deprecated because it is no longer maintained.
2.0.0-alpha.10 207 8/10/2021 2.0.0-alpha.10 is deprecated because it is no longer maintained.
2.0.0-alpha.9 191 8/9/2021 2.0.0-alpha.9 is deprecated because it is no longer maintained.
2.0.0-alpha.8 171 8/6/2021 2.0.0-alpha.8 is deprecated because it is no longer maintained.
2.0.0-alpha.7 190 8/6/2021 2.0.0-alpha.7 is deprecated because it is no longer maintained.
2.0.0-alpha.6 184 8/6/2021 2.0.0-alpha.6 is deprecated because it is no longer maintained.
2.0.0-alpha.5 199 8/6/2021 2.0.0-alpha.5 is deprecated because it is no longer maintained.
2.0.0-alpha.4 212 8/6/2021 2.0.0-alpha.4 is deprecated because it is no longer maintained.
2.0.0-alpha.3 214 8/6/2021 2.0.0-alpha.3 is deprecated because it is no longer maintained.
2.0.0-alpha.2 188 8/6/2021 2.0.0-alpha.2 is deprecated because it is no longer maintained.
2.0.0-alpha.1 184 8/6/2021 2.0.0-alpha.1 is deprecated because it is no longer maintained.
1.2.0 1,216 5/29/2021 1.2.0 is deprecated because it is no longer maintained.
1.1.0 506 5/16/2021 1.1.0 is deprecated because it is no longer maintained.
1.0.1 411 5/16/2021 1.0.1 is deprecated because it is no longer maintained.
1.0.0 447 5/16/2021 1.0.0 is deprecated because it is no longer maintained.
0.0.1-alpha.14 338 4/17/2021 0.0.1-alpha.14 is deprecated because it is no longer maintained.
0.0.1-alpha.13 241 4/11/2021 0.0.1-alpha.13 is deprecated because it is no longer maintained.
0.0.1-alpha.12 207 4/10/2021 0.0.1-alpha.12 is deprecated because it is no longer maintained.
0.0.1-alpha.11 472 3/5/2021 0.0.1-alpha.11 is deprecated because it is no longer maintained.
0.0.1-alpha.10 209 2/25/2021 0.0.1-alpha.10 is deprecated because it is no longer maintained.
0.0.1-alpha.9 212 2/25/2021 0.0.1-alpha.9 is deprecated because it is no longer maintained.
0.0.1-alpha.8 220 2/25/2021 0.0.1-alpha.8 is deprecated because it is no longer maintained.
0.0.1-alpha.7 219 2/24/2021 0.0.1-alpha.7 is deprecated because it is no longer maintained.
0.0.1-alpha.6 195 2/23/2021 0.0.1-alpha.6 is deprecated because it is no longer maintained.
0.0.1-alpha.5 196 2/22/2021 0.0.1-alpha.5 is deprecated because it is no longer maintained.
0.0.1-alpha.4 181 2/17/2021 0.0.1-alpha.4 is deprecated because it is no longer maintained.
0.0.1-alpha.3 184 2/17/2021 0.0.1-alpha.3 is deprecated because it is no longer maintained.
0.0.1-alpha.2 176 2/16/2021 0.0.1-alpha.2 is deprecated because it is no longer maintained.
0.0.1-alpha.1 172 2/16/2021 0.0.1-alpha.1 is deprecated because it is no longer maintained.