AccountSubSystem.Repositories 1.0.0

AccountSubSystem.Repositories

EF Core database repositories for the BDJobs Account SubSystem.

This package provides the data access layer for the Account SubSystem. It uses Entity Framework Core with SQL Server to query and persist account-related data, following the Repository pattern used across all BDJobs subsystems.

📦 Installation

.NET CLI

dotnet add package AccountSubSystem.Repositories --version 1.0.0

Package Manager Console

NuGet\Install-Package AccountSubSystem.Repositories -Version 1.0.0

PackageReference (add to your .csproj)

<PackageReference Include="AccountSubSystem.Repositories" Version="1.0.0" />

📋 Requirements

📁 What's Inside

This package contains:

• DbContext — EF Core context configured for SQL Server
• Repository classes — one per aggregate, e.g. UserRepository, AccountRepository
• DI registration extensions — AddAccountRepositories() extension method to register everything in one line

🚀 Usage

Step 1 — Register repositories in Program.cs

builder.Services.AddAccountRepositories(builder.Configuration);

Step 2 — Inject the repository into your Handler

using AccountSubSystem.Repositories;

public class GetUserQueryHandler
{
    private readonly IUserRepository _userRepository;

    public GetUserQueryHandler(IUserRepository userRepository)
    {
        _userRepository = userRepository;
    }

    public async Task<UserResponseDto> Handle(GetUserQuery query)
    {
        var entities = await _userRepository.GetByIdAsync(query.UserId);

        var aggregateRoot = UserAggregateRoot.FromEntities(entities);
        return aggregateRoot.ToResponseDto();
    }
}

Step 3 — Connection string in appsettings.json

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=YOUR_SERVER;Database=YOUR_DB;Trusted_Connection=True;"
  }
}

🔗 Dependencies

All dependencies are installed automatically.

🏗️ Architecture

AccountSubSystem.Repositories sits in the infrastructure layer — it talks to the database and feeds data to the domain (Aggregators).

AccountSubSystem.Handlers
    └── AccountSubSystem.Repositories  ← YOU ARE HERE
        └── AccountSubSystem.Aggregators
            └── AccountSubSystem.DTOs

Data flow:

Handler calls Repository
    → Repository queries SQL Server via EF Core
    → Returns raw entities to Handler
    → Handler passes entities to AggregateRoot

⚠️ Notes

• This package requires a SQL Server connection string in your appsettings.json.
• The DbContext uses EF Core migrations — run dotnet ef database update if you are setting up a new environment.
• Never inject DbContext directly in your API layer — always go through the Repository interface.

👤 Author

BDJobs — Internal NuGet package for the BDJobs Conveyance Billing System.