SimpleEfCoreRepository 1.0.3

EF.Core.Repository

Simple repository for Ef.Core with basic CRUD functionality The reason I implemented this is because I found myself re-writing basic CRUD functionality over and over again. Most of the time:

• use .include(...) to include eager load associated entities
• update (add/delete/update) children properties by Id

NuGet

Basic setup

• Entity should implement IEntity<TId>

public class DummyModel : IEntity<int>
{
    public int Id { get; set; }
    
    public string Name { get; set; }

    public List<Nested> Children { get; set; }
}

• Create profile which is used to update an entity given a DTO

public class DummyModelProfile : IEntityProfile<DummyModel, int> 
{
    private readonly IEntityProfileAuxiliary _auxiliary;

    // Optionally inject utility for list add/delete
    public DummyModelProfile(IEntityProfileAuxiliary auxiliary)
    {
        _auxiliary = auxiliary;
    }

    public DummyModel Update(DummyModel entity, DummyModel dto)
    {
        entity.Name = dto.Name;

        // ModifyList will try to add/delete entities based on Id based on whether they
        // appear in dto.Children or not 
        entity.Children = _auxiliary.ModifyList<Nested, int>(entity.Children, dto.Children);

        // Return entity or response
        // This will be used as a return value for update method in BasicCrud
        return entity;
    }

    // Intercept IQueryable to include related entities
    public IQueryable<DummyModel> Include<TQueryable>(TQueryable queryable) where TQueryable : IQueryable<DummyModel>
    {
        return queryable.Include(x => x.Children);
    }
}

• Register dependency via IServiceCollection extension

var serviceProvider = services
    .AddEfRepository<EntityDbContext>(options => options
        .Profiles(Assembly.GetExecutingAssembly()));

• Use IBasicCrud

IEfRepository repo = ... // DI inject IEfRepository

// Get IBasicCrud instance
IBasicCrud<DummyModel> = repo.For<DummyModel>();

• Available methods in IBasicCrud

Task<IEnumerable<TSource>> GetAll();

Task<TSource> Get(id);

Task<TSource> Save(dto);

Task<TSource> Delete(id);

Task<TSource> Update(id, dto);