the-biergarten-app/web/backend/Infrastructure/Infrastructure.Repository/Repository.cs

using System.Data.Common;
using Infrastructure.Repository.Sql;

namespace Infrastructure.Repository;

public abstract class Repository<T>(ISqlConnectionFactory connectionFactory)
    where T : class
{
    protected async Task<DbConnection> CreateConnection()
    {
        var connection = connectionFactory.CreateConnection();
        await connection.OpenAsync();
        return connection;
    }

    protected abstract T MapToEntity(DbDataReader reader);
}