RGHB.DBCommons 1.3.1

RGHB.Commons

Overview

RGHB.Commons is a .NET 9.0 library designed to provide reusable utilities and services for building data-driven applications using Entity Framework Core. It includes a generic repository pattern implementation, extension methods for query pagination, and database initialization interfaces.

Features

• Generic Repository Pattern: GenericService<TEntity> provides a robust, type-safe implementation for CRUD operations and querying with Entity Framework Core.
• Pagination Support: EFGeneralService offers a Page extension method for easy query pagination.
• Unit of Work Pattern: IUnitOfWork interface defines methods for managing database transactions and entity state.
• Database Initialization: IDbInitializerService interface for initializing and seeding the database.
• Flexible Querying: Supports filtering, ordering, eager loading, and projections for efficient data retrieval.

Installation

1. Clone the repository or include the project as a dependency in your .NET solution.
2. Ensure the following NuGet packages are installed:
   • Microsoft.EntityFrameworkCore (v9.0.2)
   • Microsoft.AspNetCore.Mvc.ViewFeatures (v2.3.0)
3. Build the project using .NET 9.0 SDK.

Usage

GenericService

The GenericService<TEntity> class provides methods for common database operations. Example:

var service = new GenericService<MyEntity>(unitOfWork);
var entities = await service.GetPagingAsync(
    pageNumZeroStart: 0,
    pageSize: 10,
    orderBy: q => q.OrderBy(e => e.Id),
    includeProperties: "RelatedEntity"
);

Pagination

Use the Page extension method for paginated queries:

var query = dbContext.MyEntities.AsQueryable();
var pagedResult = query.Page(pageNumZeroStart: 1, pageSize: 20);

Database Initialization

Implement IDbInitializerService to initialize and seed your database:

public class MyDbInitializer : IDbInitializerService
{
    public void Initialize() { /* Apply migrations */ }
    public void SeedData() { /* Add default data */ }
}

Project Structure

• GeneralServices.cs: Contains the EFGeneralService class with pagination utilities.
• GenericService.cs: Implements the generic repository pattern for Entity Framework Core.
• IDbInitializerService.cs: Interface for database initialization and seeding.
• IGenericService.cs: Interface for the generic repository pattern.
• IUnitOfWork.cs: Interface for the unit of work pattern.

Dependencies

• .NET 9.0
• Microsoft.EntityFrameworkCore (v9.0.2)
• Microsoft.AspNetCore.Mvc.ViewFeatures (v2.3.0)

License

This project is licensed under the MIT License.