NPv.DataAccess.Dapper.Executor 1.0.3

NPv.DataAccess.Dapper.Executor

Dapper-based implementation of the ISqlExecutor interface from NPv.DataAccess.Abstractions. Provides simple, consistent access to raw SQL queries without manual connection handling.

✨ Overview

This library offers a lightweight executor for raw SQL queries and commands using Dapper and SqlClient.

It is designed to:

• Minimize boilerplate code (no using SqlConnection on every query)
• Standardize SQL access behind the ISqlExecutor abstraction
• Fit cleanly into DI, CQRS, and layered architectures

🔧 Features

• Executes raw SQL queries (SELECT, INSERT, UPDATE, DELETE)
• Wraps common Dapper methods: -- QueryFirstAsync -- QueryFirstOrDefaultAsync -- QuerySingleAsync -- QuerySingleOrDefaultAsync -- QueryAsync -- ExecuteAsync
• Manages connection lifecycle internally
• Uses connection string from IConfiguration ("Default" key expected)

🧩 Example Usage

public class GetProductByIdHandler(ISqlExecutor sql) : IQueryHandler<Guid, ProductDto?>
{
    public async Task<ProductDto?> HandleAsync(Guid id)
    {
        const string sqlQuery = "SELECT Id, Name, Price FROM Products WHERE Id = @id";
        return await sql.QueryFirstOrDefaultAsync<ProductDto>(sqlQuery, new { id });
    }
}

📦 Installation

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

To install via NuGet:

dotnet add package NPv.DataAccess.Dapper.Executor

🛠️ Setup in DI

In your startup configuration:

services.AddScoped<ISqlExecutor, DapperSqlExecutor>();

Make sure your appsettings.json contains a valid connection string:

{
  "ConnectionStrings": {
    "Default": "Server=...;Database=...;User Id=...;Password=...;"
  }
}

🔗 Related Packages

• NPv.DataAccess.Abstractions — Interface definition (ISqlExecutor) -- NPv.DataAccess.Ef — EF Core implementation of IGenericRepository

📁 Project Structure

NPv.DataAccess.Dapper.Executor
├── DapperSqlExecutor.cs
├── ISqlExecutor (from Abstractions)

Author's Note

This library grew out of my long-standing personal interest in structuring and publishing open source packages. Over time, I’ve revisited and refined earlier internal utilities and ideas, giving them a more consistent shape and preparing them for wider reuse. Along the way, I’ve also taken the opportunity to explore how open source distribution and licensing work in the .NET ecosystem.

It’s a small step toward something I’ve always wanted to try — sharing practical, minimal tools that reflect years of learning, experimentation, and refinement.

Hopefully, someone finds it useful.

Nikolai 😛

⚖️ License

MIT — you are free to use this in commercial and open-source software.