Acontplus.Persistence.PostgreSQL 1.0.2

There is a newer version of this package available.
See the version list below for details.

dotnet add package Acontplus.Persistence.PostgreSQL --version 1.0.2

NuGet\Install-Package Acontplus.Persistence.PostgreSQL -Version 1.0.2

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="Acontplus.Persistence.PostgreSQL" Version="1.0.2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Acontplus.Persistence.PostgreSQL" Version="1.0.2" />
                    

                            Directory.Packages.props

<PackageReference Include="Acontplus.Persistence.PostgreSQL" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add Acontplus.Persistence.PostgreSQL --version 1.0.2

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

#r "nuget: Acontplus.Persistence.PostgreSQL, 1.0.2"

#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.

#:package Acontplus.Persistence.PostgreSQL@1.0.2

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=Acontplus.Persistence.PostgreSQL&version=1.0.2
                    

                            Install as a Cake Addin

#tool nuget:?package=Acontplus.Persistence.PostgreSQL&version=1.0.2
                    

                            Install as a Cake Tool

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

Acontplus.Persistence.PostgreSQL

A .NET 9+ library for PostgreSQL persistence, ADO.NET, and Entity Framework Core integration. Includes repositories, context management, and advanced error handling for robust data access with PostgreSQL.

🚀 Features

Database context management - Base context and factory for EF Core
Repository pattern - Generic and ADO.NET repositories
PostgreSQL integration - Optimized for PostgreSQL
Data reader mapping utilities - Fast mapping from DbDataReader
Parameter handling helpers - Safe and flexible parameterization
Advanced error handling - Custom exceptions and translators

📦 Installation

NuGet Package Manager

Install-Package Acontplus.Persistence.PostgreSQL

.NET CLI

dotnet add package Acontplus.Persistence.PostgreSQL

PackageReference

<ItemGroup>
  <PackageReference Include="Acontplus.Persistence.PostgreSQL" Version="1.0.0" />
</ItemGroup>

🎯 Quick Start

1. Register DbContext and Repository

services.AddDbContext<BaseContext>(options =>
    options.UseNpgsql(Configuration.GetConnectionString("DefaultConnection")));
services.AddScoped(typeof(IRepository<,>), typeof(BaseRepository<,>));

2. Use ADO.NET Repository

var repo = serviceProvider.GetRequiredService<IAdoRepository>();
var result = await repo.ExecuteQueryAsync("SELECT * FROM MyTable");

🔧 Advanced Usage

Custom Exception Handling

try {
    // ... data access code ...
} catch (RepositoryException ex) {
    // handle repository errors
}

DataTable Mapping

var entities = DbDataReaderMapper.MapToList<MyEntity>(reader);

📚 API Documentation

BaseContext - EF Core base context
DbContextFactory - Context factory
BaseRepository / AdoRepository - Repository implementations
RepositoryException, SqlDomainException, UnitOfWorkException - Error handling
DbDataReaderMapper - Data reader mapping
DataTableNameMapper - Table name helpers

🤝 Contributing

We welcome contributions! Please see our Contributing Guidelines for details.

Development Setup

git clone https://github.com/Acontplus-S-A-S/acontplus-dotnet-libs.git
cd acontplus-dotnet-libs
dotnet restore
dotnet build

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🆘 Support

📧 Email: proyectos@acontplus.com
🐛 Issues: GitHub Issues
📖 Documentation: Wiki

👨‍💻 Author

Ivan Paz - @iferpaz7

🏢 Company

Acontplus S.A.S. - Software solutions

Built with ❤️ for the .NET community

Product	Compatible and additional computed target framework versions.
.NET	net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. 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.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net9.0
- Acontplus.Core (>= 1.4.7)
- Acontplus.Persistence.Common (>= 1.1.6)
- Microsoft.EntityFrameworkCore (>= 9.0.8)
- Microsoft.Extensions.Caching.Memory (>= 9.0.8)
- Microsoft.Extensions.Configuration.Abstractions (>= 9.0.8)
- Microsoft.Extensions.DependencyInjection (>= 9.0.8)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 9.0.8)
- Microsoft.Extensions.Logging.Abstractions (>= 9.0.8)
- Npgsql (>= 9.0.3)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 9.0.4)
- Polly (>= 8.6.2)

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
1.3.1	76	1/16/2026
1.3.0	85	1/11/2026
1.2.9	90	1/1/2026
1.2.8	173	12/25/2025
1.2.7	170	12/23/2025
1.2.6	280	12/16/2025
1.2.5	113	12/11/2025
1.2.4	167	12/5/2025
1.2.3	191	12/4/2025
1.2.2	194	12/3/2025
1.2.1	178	11/28/2025
1.2.0	188	11/23/2025
1.1.8	395	11/17/2025
1.1.7	409	11/17/2025
1.1.6	407	11/17/2025
1.1.5	286	11/11/2025
1.1.4	197	11/6/2025
1.1.3	201	11/6/2025
1.1.2	196	11/6/2025
1.1.1	199	11/5/2025
1.1.0	200	11/5/2025
1.0.12	191	10/23/2025
1.0.11	171	9/26/2025
1.0.10	186	9/25/2025
1.0.9	179	9/24/2025
1.0.8	247	9/14/2025
1.0.7	240	9/14/2025
1.0.6	243	9/14/2025
1.0.5	208	9/10/2025
1.0.4	191	9/9/2025
1.0.3	219	8/24/2025
1.0.2	184	8/21/2025
1.0.1	183	8/19/2025
1.0.0	191	8/12/2025

Enhanced with contemporary repository patterns, Entity Framework Core integration, Npgsql support, advanced error handling, connection resilience with Polly, and enterprise-ready PostgreSQL data access patterns.