efcore-repos

EF Core Repositories Skill

This skill helps GitHub Copilot generate code using DKNet's EF Core Repositories package (DKNet.EfCore.Repos) for implementing the Repository pattern with Entity Framework Core.

🎯 Package Purpose

DKNet.EfCore.Repos provides:

• Repository Pattern - Abstract data access with repositories
• Generic Repositories - Type-safe repositories for any entity
• CQRS Support - Separate read/write repositories
• Mapster Integration - Efficient projections for DTOs
• Transaction Management - Built-in transaction support

NuGet Package: DKNet.EfCore.Repos

📦 Installation

dotnet add package DKNet.EfCore.Repos
dotnet add package DKNet.EfCore.Repos.Abstractions
dotnet add package Mapster

🏗️ Setup

Register Repositories

using Microsoft.Extensions.DependencyInjection;
using DKNet.EfCore.Repos;

public void ConfigureServices(IServiceCollection services)
{
    // Add DbContext
    services.AddDbContext<AppDbContext>(options =>
        options.UseSqlServer(connectionString));
    
    // Add Mapster for projections
    services.AddMapster();
    
    // Register generic repositories
    services.AddGenericRepositories<AppDbContext>();
    
    // Or register specific repositories
    services.AddScoped<IProductRepository, ProductRepository>();
}

🎯 Usage Patterns

Pattern 1: Generic Repository

Use built-in generic repository for simple CRUD:

using DKNet.EfCore.Repos.Abstractions;

public class ProductService
{
    private readonly IRepository<Product> _repository;
    
    public ProductService(IRepository<Product> repository)
    {
        _repository = repository;
    }
    
    public async Task<Product> CreateProductAsync(
        CreateProductRequest request,
        CancellationToken cancellationToken)
    {
        var product = new Product
        {
            Name = request.Name,
            Price = request.Price,
            CategoryId = request.CategoryId
        };
        
        await _repository.AddAsync(product, cancellationToken);
        await _repository.SaveChangesAsync(cancellationToken);
        
        return product;
    }
    
    public async Task<Product?> GetProductAsync(
        Guid id,
        CancellationToken cancellationToken)
    {
        return await _repository.GetByIdAsync(id, cancellationToken);
    }
    
    public async Task<IReadOnlyList<Product>> GetAllProductsAsync(
        CancellationToken cancellationToken)
    {
        var spec = new ActiveProductsSpec();
        return await _repository.ToListAsync(spec, cancellationToken);
    }
    
    public async Task UpdateProductAsync(
        Product product,
        CancellationToken cancellationToken)
    {
        await _repository.UpdateAsync(product, cancellationToken);
        await _repository.SaveChangesAsync(cancellationToken);
    }
    
    public async Task DeleteProductAsync(
        Guid id,
        CancellationToken cancellationToken)
    {
        await _repository.DeleteAsync(id, cancellationToken);
        await _repository.SaveChangesAsync(cancellationToken);
    }
}