ISC.Dapper.SqlClient.DependencyInjection 1.0.0

ISC.Dapper.SqlClient.DependencyInjection

ISC.Dapper.SqlClient.DependencyInjection is a lightweight package that provides:

• IDapperContext abstraction for Dapper operations.
• DapperContext implementation for SQL Server.
• A simple foundation for building your own app-level context factory pattern.

Target Framework

• .NET 8.0

Installation

dotnet add package ISC.Dapper.SqlClient.DependencyInjection

Quick Start

1) Register your factory in the application

using ISC.Dapper.SqlClient.DependencyInjection;

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddScoped<DapperContextFactory>();

2) Implement DapperContextFactory

This example follows your read/write factory approach:

using ISC.Dapper.SqlClient.DependencyInjection;

public class DapperContextFactory
{
    private readonly IConfiguration _configuration;
    private readonly string _connectionStringRead;
    private readonly string _connectionStringWrite;

    public DapperContextFactory(IConfiguration configuration)
    {
        _configuration = configuration;
        _connectionStringRead = _configuration.GetConnectionString("ChannelHubsService")
            ?? "";
        _connectionStringWrite = _configuration.GetConnectionString("ChannelHubsService")
            ?? "";
    }

    public IDapperContext ReInventReadContext() => new DapperContext(_connectionStringRead);
    public IDapperContext ReInventWriteContext() => new DapperContext(_connectionStringWrite);
    public string GetConnectionStringWrite() => _connectionStringWrite;
}

3) Use the factory in services/repositories

using ISC.Dapper.SqlClient.DependencyInjection;

public sealed class UserRepository
{
    private readonly DapperContextFactory _contextFactory;

    public UserRepository(DapperContextFactory contextFactory)
    {
        _contextFactory = contextFactory;
    }

    public async Task<IEnumerable<UserDto>> GetUsersAsync()
    {
        var dapperContext = _contextFactory.ReInventReadContext();
        const string sql = "SELECT Id, UserName FROM dbo.Users";
        return await dapperContext.QueryAsync<UserDto>(sql);
    }
}

API Overview

IDapperContext

• QueryAsync<T>(...)
• QuerySingleAsync<T>(...)
• ExecuteAsync(...)
• ExecuteScalarAsync<T>(...)
• BeginTransactionAsync()
• CommitTransaction(...)
• RollbackTransaction(...)
• OpenConnection()
• CloseConnection()

Best Practices

• Prefer separate read/write connection strings when your infrastructure supports it.
• Throw early if a required connection string is missing.
• Keep one consistent context creation strategy across your application.

License

Add your project license here (for example: MIT).