NPv.DataAccess.Abstractions 1.1.1

NPv.DataAccess.Abstractions

Minimal interface contract for generic repository access in .NET applications.

✨ Overview

This library defines core abstractions for working with persistent data in a clean, provider-agnostic way. It includes:

• IGenericRepository — for standard CRUD operations on aggregate roots or entities
• ISqlExecutor — for executing raw SQL queries and commands asynchronously

These abstractions are designed to support layered architectures, promote separation of concerns, and enable swapping implementations (e.g., EF Core, Dapper) with minimal friction.

🧱 Interfaces

IGenericRepository

Standard CRUD contract for entity-oriented persistence:

Task<TEntity?> GetAsync<TEntity>(Guid id, string includeProperties = "");
Task<TEntity?> GetAsync<TEntity>(Expression<Func<TEntity, bool>>? filter, string includeProperties = "");
Task<IEnumerable<TEntity>> ListAsync<TEntity>(...);
Task<int> CountAsync<TEntity>(...);
Task AddAsync<TEntity>(TEntity entity);
Task DeleteAsync<TEntity>(Guid id);
...

ISqlExecutor

Lightweight abstraction over raw SQL execution, ideal for high-performance scenarios using Dapper or similar tools:

    Task<T> QueryFirstAsync<T>(string sql, object? parameters = null);
    Task<T?> QueryFirstOrDefaultAsync<T>(string sql, object? parameters = null);
    Task<T> QuerySingleAsync<T>(string sql, object? parameters = null);
    Task<T?> QuerySingleOrDefaultAsync<T>(string sql, object? parameters = null);
    Task<IEnumerable<T>> QueryAsync<T>(string sql, object? parameters = null);
    Task<int> ExecuteAsync(string sql, object? parameters = null);
...

🔧 Usage

Implement the interface in your data layer (e.g., using EF Core):

For IGenericRepository

public class EfGenericRepository : IGenericRepository { ... }

For ISqlExecutor

Implement using your SQL technology of choice, e.g. via Dapper:

public class DapperSqlExecutor : ISqlExecutor { ... }

Inject ISqlExecutor where you need to run raw SQL without managing connections or boilerplate manually.

📦 Installation

This package is published as part of the NPv.Foundation.Net architecture.

To install via NuGet:

dotnet add package NPv.DataAccess.Abstractions

🧩 Related Packages

• NPv.DataAccess.Ef – EF Core implementation of IGenericRepository
• NPv.DataAccess.Dapper.Executor – Dapper-based implementation of ISqlExecutor