ProfileService 1.2.2

ProfileLib

A lightweight, extensible profile management library for .NET applications that provides a clean architecture approach to handling profile data with dynamic query building.

Features

• 🎯 Base profile entity with audit properties
• 💾 Generic repository pattern
• 🔍 Dynamic query building with type safety
• 📄 Built-in pagination support
• 🗃️ Multiple database provider support
• 🧱 Easy to extend and customize

Installation

dotnet add package ProfileLib

Add your preferred database provider:

dotnet add package Microsoft.EntityFrameworkCore.SqlServer
# or
dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL
# or
dotnet add package Pomelo.EntityFrameworkCore.MySql
# or
dotnet add package Microsoft.EntityFrameworkCore.Sqlite

Usage

1. Create your profile class:

public class CustomerProfile : ProfileBase
{
    public string? CompanyName { get; private set; }
    public string? Department { get; private set; }

    private CustomerProfile() : base() { }

    public static CustomerProfile Create(string name, string email, string? companyName = null)
    {
        return new CustomerProfile
        {
            Name = name,
            Email = email.ToLower(),
            CompanyName = companyName
        };
    }
}

2. Create your repository:

public class CustomerProfileRepository : BaseProfileRepository<CustomerProfile>
{
    public CustomerProfileRepository(
        CustomerDbContext context,
        ILogger<CustomerProfileRepository> logger)
        : base(context, logger)
    {
    }
}

3. Configure services:

services.AddProfileService<CustomerProfile, CustomerDbContext, CustomerProfileRepository>(
    Configuration,
    Configuration.GetConnectionString("DefaultConnection")!,
    DatabaseProvider.SQLServer);

4. Use the QueryBuilder:

public class CustomerService
{
    private readonly IProfileRepositoryBase<CustomerProfile> _repository;

    public async Task<List<CustomerProfile>> SearchAsync(string? name, string? company)
    {
        var predicate = new QueryBuilder<CustomerProfile>()
            .WhenNotNullOrEmpty(name, x => x.Name.Contains(name))
            .WhenNotNullOrEmpty(company, x => x.CompanyName == company)
            .Build();

        return await _repository.Query()
            .FindAsync(predicate, "Name", take: 10);
    }

    public async Task<(List<CustomerProfile>, int)> GetPaginatedAsync(
        string? name, 
        string? company,
        int page = 1,
        int pageSize = 10)
    {
        var predicate = new QueryBuilder<CustomerProfile>()
            .WhenNotNullOrEmpty(name, x => x.Name.Contains(name))
            .WhenNotNullOrEmpty(company, x => x.CompanyName == company)
            .Build();

        return await _repository.Query()
            .PaginateAsync(predicate, "Name", pageNumber: page, pageSize: pageSize);
    }
}

Query Building

The QueryBuilder<T> provides fluent methods for building type-safe queries:

var predicate = new QueryBuilder<CustomerProfile>()
    .WithCondition(x => x.Status == ProfileStatus.Active)
    .WhenNotNull(company, x => x.CompanyName == company)
    .WhenHasValue(salary, x => x.Salary >= salary)
    .WhenNotNullOrEmpty(name, x => x.Name.Contains(name))
    .Build();

Supported Database Providers

• SQL Server
• PostgreSQL
• MySQL
• SQLite

Base Profile Properties

public abstract class ProfileBase
{
    public Guid Id { get; protected set; }
    public string Name { get; protected set; }
    public string Email { get; protected set; }
    public DateTime CreatedAt { get; protected set; }
    public DateTime? UpdatedAt { get; protected set; }
    public string? CreatedBy { get; protected set; }
    public string? UpdatedBy { get; protected set; }
    public ProfileStatus Status { get; protected set; }
}

License

This project is licensed under the MIT License - see the LICENSE file for details.

ProfileLib

A flexible and extensible profile management library for .NET applications with support for multiple database providers, built with Clean Architecture principles.

Features

• 🎯 Clean Architecture Design
• 💾 Multiple Database Provider Support
  • SQL Server
  • PostgreSQL
  • MySQL
  • SQLite
• 🔄 Generic Repository Pattern