Acontplus.Persistence.PostgreSQL 1.0.3

.NET 9.0

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

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

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

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

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

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

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

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

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

                            Install as a Cake Addin

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

                            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.3)

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.0.3	12	8/24/2025
1.0.2	90	8/21/2025
1.0.1	88	8/19/2025
1.0.0	117	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.