PostgreSQL integration for NuvTools.Data.EntityFrameworkCore with simplified DbContext registration, configuration from appsettings.json, and snake_case naming convention support.
Nuv Tools Data Libraries are a set of .NET libraries designed to simplify and standardize data access and manipulation. They provide abstractions and helpers for common data operations, as well as seamless integration with Entity Framework Core for SQL Server and PostgreSQL.
🎯 Key Features
Multi-Framework Support: .NET 8, .NET 9, and .NET 10
ORM-Agnostic Core: Base paging and sorting utilities work with any data source
EF Core Integration: First-class support for Entity Framework Core 10.0
Result Pattern: All database operations return IResult or IResult<T> for consistent error handling
Async-First: All EF Core operations are async with CancellationToken support
Bulk Operations: Efficient bulk add, update, and remove operations
Well-Documented: Comprehensive XML documentation for IntelliSense support
📦 Libraries Overview
NuvTools.Data
Core library with generic helpers for data manipulation:
Paging: Abstracts paging logic for both IQueryable and IEnumerable collections
Sorting: Extension methods for sorting with ascending/descending direction
Filtering: Paging filters with optional sorting capabilities
No dependencies: Works with any data source or ORM
dotnet add package NuvTools.Data
NuvTools.Data.EntityFrameworkCore
Extensions for Entity Framework Core:
DbContextBase: Base class with CRUD operations using Result pattern
Transaction Management: Built-in transaction support with rollback/commit
Execution Strategies: Connection resiliency with automatic retry
using NuvTools.Data.Paging;
// In-memory paging (0-indexed)
var items = new List<Product> { /* ... */ };
var pagedResult = items.PagingWrap(pageIndex: 0, pageSize: 20);
Console.WriteLine($"Page {pagedResult.PageIndex + 1} of {Math.Ceiling(pagedResult.Total / 20.0)}");
foreach (var item in pagedResult.List)
{
Console.WriteLine(item.Name);
}
Sorting (NuvTools.Data)
using NuvTools.Data.Sorting;
using NuvTools.Data.Sorting.Enumerations;
var sortedProducts = products
.Sort(p => p.Category, SortDirection.ASC)
.ThenSort(p => p.Price, SortDirection.DESC);
SQL Server Registration (NuvTools.Data.EntityFrameworkCore.SqlServer)
using NuvTools.Data.EntityFrameworkCore.SqlServer.Extensions;
// In Program.cs or Startup.cs
builder.Services.AddDatabaseByConnectionName<MyDbContext>("DefaultConnection");
// Or with connection string directly
builder.Services.AddDatabase<MyDbContext>(connectionString);
// With SQL Server-specific options
builder.Services.AddDatabaseByConnectionName<MyDbContext>(
"DefaultConnection",
sqlServerOptions => sqlServerOptions.EnableRetryOnFailure()
);
PostgreSQL with Snake Case (NuvTools.Data.EntityFrameworkCore.PostgreSQL)
using NuvTools.Data.EntityFrameworkCore.PostgreSQL.Extensions;
// Register DbContext
builder.Services.AddDatabaseByConnectionName<MyDbContext>("PostgresConnection");
// In your DbContext
public class MyDbContext : DbContextBase
{
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
// Apply snake_case naming convention for PostgreSQL
modelBuilder.UseSnakeCaseNamingConvention();
base.OnModelCreating(modelBuilder);
}
}
Using DbContextBase
using NuvTools.Data.EntityFrameworkCore.Context;
public class MyDbContext : DbContextBase
{
public MyDbContext(DbContextOptions<MyDbContext> options) : base(options) { }
public DbSet<Product> Products { get; set; }
}
// In your service
public class ProductService
{
private readonly MyDbContext _context;
public async Task<IResult<int>> CreateProductAsync(Product product)
{
// AddAndSaveAsync returns IResult<TKey>
return await _context.AddAndSaveAsync<Product, int>(product);
}
public async Task<IResult> UpdateProductAsync(Product product, int id)
{
// UpdateAndSaveAsync returns IResult
return await _context.UpdateAndSaveAsync(product, id);
}
public async Task<IResult> DeleteProductAsync(int id)
{
// RemoveAndSaveAsync returns IResult
return await _context.RemoveAndSaveAsync<Product>(id);
}
}
Async Paging with EF Core
using NuvTools.Data.EntityFrameworkCore.Paging;
public async Task<PagingWithEnumerableList<Product>> GetProductsAsync(int pageIndex, int pageSize)
{
var query = _context.Products.Where(p => p.IsActive);
// PagingWrapAsync materializes the data (0-indexed)
var pagedResult = await query.PagingWrapWithEnumerableListAsync(pageIndex, pageSize);
return pagedResult;
}
Bulk Operations
// Sync from list: Add new, update existing, remove missing
var result = await _context.SyncFromListAsync(
updatedProducts,
p => p.Id,
p => p.IsActive // Optional filter
);
// Add or update only (no removal)
await _context.AddOrUpdateFromListAsync(products, p => p.Id);
// Add or remove only (no updates)
await _context.AddOrRemoveFromListAsync(products, p => p.Id);
📋 Requirements
.NET SDK: 8.0, 9.0, or 10.0
Entity Framework Core: 10.1.0 (for EF Core libraries)
