AwadyLab.EFCatalyst.PostgreSql
1.0.2
dotnet add package AwadyLab.EFCatalyst.PostgreSql --version 1.0.2
NuGet\Install-Package AwadyLab.EFCatalyst.PostgreSql -Version 1.0.2
<PackageReference Include="AwadyLab.EFCatalyst.PostgreSql" Version="1.0.2" />
<PackageVersion Include="AwadyLab.EFCatalyst.PostgreSql" Version="1.0.2" />
<PackageReference Include="AwadyLab.EFCatalyst.PostgreSql" />
paket add AwadyLab.EFCatalyst.PostgreSql --version 1.0.2
#r "nuget: AwadyLab.EFCatalyst.PostgreSql, 1.0.2"
#:package AwadyLab.EFCatalyst.PostgreSql@1.0.2
#addin nuget:?package=AwadyLab.EFCatalyst.PostgreSql&version=1.0.2
#tool nuget:?package=AwadyLab.EFCatalyst.PostgreSql&version=1.0.2
AwadyLab.EFCatalyst.PostgreSql
PostgreSQL (Npgsql) support for AwadyLab.EFCatalyst: deadlock detection and PostgreSQL SQL for the EFCatalyst migration operations.
Overview
The package registers, in EF Core's internal service provider, a PostgreSQL dialect (deadlock detection, seed-history DDL) and a migrations SQL generator that translates the EFCatalyst migration operations and delegates everything else to the Npgsql provider's own generator.
Key Highlights
- Concurrency: the database does not maintain
IRowVersion, so the save pipeline's concurrency step rotates the token; a conflict throwsEFCatalystConcurrencyException. - Deadlock Detection: SQLSTATE 40P01 is recognised, so
DeadlockRetryInterceptorcan retry the command (outside transactions). - Migration Helpers in PostgreSQL SQL: views, functions,
ON CONFLICTupserts, soft-delete and timestamp triggers, and filtered indexes.
Installation
dotnet add package AwadyLab.EFCatalyst.PostgreSql
Quickstart
services.AddDbContext<ShopContext>((sp, o) => o
.UseNpgsql(connectionString)
.UseEFCatalystPostgreSql()
.UseEFCatalystInterceptors(sp));
If you replace IMigrationsSqlGenerator yourself, derive from the EFCatalyst one or call
UseEFCatalystPostgreSql() after your replacement.
License
Proprietary — see the core package, AwadyLab.EFCatalyst.
Full documentation lives in the core package's repository (README.md).
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- AwadyLab.EFCatalyst (>= 1.0.2)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 10.0.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.