DKX.Pg 2.0.0

Prefix Reserved

This package has been deprecated as it is legacy and is no longer maintained.

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

NuGet\Install-Package DKX.Pg -Version 2.0.0

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" />

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

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: DKX.Pg, 2.0.0"

#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

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

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
Immutable entities
Opening connection automatically when needed
Automatic nested transactions (with savepoints)
Plain SQL with snippets
.net 5 only

Installation

Install main package:

$ dotnet add package DKX.Pg
$ dotnet add package DKX.Pg.AOT

Example

using DKX.Pg;
using DKX.Pg.Entities;
using DKX.Pg.Metadata;

[Entity]
public partial class User
{
    [Id, Generated]
    public int Id { get; }
    
    public string Email { get; }
}

await using var db = new Connection(new NpgsqlConnection(connectionString), new AssemblyEntitiesMetadataProvider(assemblyWithEntities));

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.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net5.0
- Npgsql (>= 5.0.7)

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