Razory 2.1.1

Razory

Framework-agnostic repository and query object abstractions for .NET 10. Provides the core contracts shared across all database providers.

What's included

• EntityBase — base entity with Id (Guid), CreateDate, UpdateDate
• IEntityConfiguration<T> — contract for mapping an entity to a table/collection name
• IDatabaseConfiguration — contract for providing connection info and entity configurations
• IRepository — CRUD + Upsert contract using Expression<Func<T, bool>>
• IQueryObject<T> — fluent query builder
• IQueryObjectResult<T> — agnostic query result (filter, sort, paginate, project)
• IQueryObjectAggregateResult<T> — agnostic aggregate result (group, project)
• QueryObjectFilterDefinition<T> — base class for typed, reusable filter definitions

Usage

Install a provider alongside this package:

• Razory.MongoDB — MongoDB .NET Driver implementation
• Razory.EntityFramework — EF Core implementation

Defining entities

public class Product : EntityBase
{
    public string Name { get; set; }
    public string Category { get; set; }
    public bool IsActive { get; set; }
}

Defining filter definitions

public class ProductFilter : QueryObjectFilterDefinition<Product>
{
    public ProductFilter ActiveOnly()
    {
        AddFilter(p => p.IsActive);
        return this;
    }

    public ProductFilter WithCategory(string category)
    {
        AddFilter(p => p.Category == category);
        return this;
    }
}

Using IRepository and IQueryObject<T>

public class ProductService(IRepository repository, IQueryObject<Product> query)
{
    public Task<Product> GetByIdAsync(Guid id) =>
        repository.GetAsync<Product>(id);

    public Task InsertAsync(Product product) =>
        repository.InsertAsync(product);

    public Task UpsertAsync(Product product) =>
        repository.UpsertAsync(p => p.Id == product.Id, product);

    public Task<IEnumerable<Product>> GetActiveByCategoryAsync(string category) =>
        query
            .FilterBy<ProductFilter>(f => f.ActiveOnly().WithCategory(category))
            .SortAscending(p => p.Name)
            .Query()
            .GetAllAsync();

    public Task<IEnumerable<Product>> GetPageAsync(int page, int size) =>
        query
            .FilterBy(p => p.IsActive)
            .Query()
            .Skip((page - 1) * size)
            .Limit(size)
            .GetAllAsync();
}

Repository

github.com/johnyricalde/Razory