EF-Repository-Pattern 1.2.3

EF Core 6 - Generic Repository Pattern

Simple Generic Repository Pattern based on EF core 6 and Dependency Injection. To create any type of Repository based on the Context's DBSets.

How to use

In Sturtup after calling AddDbContext<TContext> you can call AddEFRepositoryPattern<TContext>()

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<MyContext>(options =>
    {
        options.UseInMemoryDatabase(databaseName: $"Select");
    });

    // You can use any type of Context. For ease we have used an inMemory
    services.AddEFRepositoryPattern<MyContext>();

    ...
}

public class MyContext : DbContext
{
    public DbSet<Customer> Customers { get; set; }
    public DbSet<Order> Orders { get; set; }
}

That's all, now you can use all reporitory you want only doing this

public class MyService {
    private readonly IRepositoryManager<MyContext> repositoryManager;

    public MyService(IRepositoryManager<MyContext> repositoryManager)
    {
        this.repositoryManager = repositoryManager;
    }

    public async Task AddCustomer()
    {
        // Create your Repository of Type Customer
        var repCustomer = repositoryManager.GenerateModelRepository<Customer>();

        var bCustomer = new Customer() { Id = 1, City = "New York", FirstName = "Liam" };
        await repCustomer.AddModelAsync(bCustomer);

        await repositoryManager.SaveChangesAsync();
    }

    public async Task AddDifferentEntitiesInOneTransaction()
    {
        // Create your Repository of Type Customer
        var repCustomer = repositoryManager.GenerateModelRepository<Customer>();

        // Adding some customers to DBSet
        await repCustomer.AddModelAsync(new Customer() { Id = 2, City = "San Diego", FirstName = "Liam" });
        await repCustomer.AddModelAsync(new Customer() { Id = 3, City = "Los Angeles" });
        await repCustomer.AddModelAsync(new Customer() { Id = 5, City = "New York", FirstName = "Noah" });
        await repCustomer.AddModelAsync(new Customer() { Id = 4, City = "Dallas" });

        // Create your Repository of Type Order
        var repOrder = repositoryManager.GenerateModelRepository<Order>();

        // Adding some customers to DBSet
        await repOrder.AddModelAsync(new Order() { Id = 1, TotalAmount= 100, Customer = bCustomer });
        await repOrder.AddModelAsync(new Order() { Id = 2, TotalAmount= 22, Customer = bCustomer });
        await repOrder.AddModelAsync(new Order() { Id = 3, TotalAmount= 67, Customer = bCustomer });

        // Save all in DB
        await repositoryManager.SaveChangesAsync();
    }

    public async Task GetCustomer()
    {
        // Create your Repository of Type Customer
        var repCustomer = repositoryManager.GenerateModelRepository<Customer>();

        // Get First Customer where City == "New York"
        var customer = await repCustomer.GetFirstModelAsync(x => x.City == "New York");

        // Get List of Customers where FirstName == Liam orderedBy City and include Orders
        var customers = await repCustomer.GetListModelsAsync(
            x => x.FirstName == "Liam",
            x => x.OrderBy(y => y.City),
            x => x.Include(y => y.Orders)
        );

        // Get AllList of Customers Order by City and FirstName
        var d = await repCustomer.GetListModelsAsync(
            orderByFunc: x => x.OrderBy(y => y.City).ThenBy(y => y.FirstName)
        );
    }
}

The method to search for a pattern by key is available. To use the GetModelByKeyAsync method, the model created via the GenerateModelRepository method must inherit from IBasePropertyKey<TKey> (otherwise the method will throw an error). TKey will set the type of the property id.

public class OrderItem: IBasePropertyKey<int>
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }
    public int OrderId { get; set; }
}
    
public async Task GetExample(){
    var repOrderItem = repositoryManager.GenerateModelRepository<OrderItem>();
    
    // OrderItem inherit from IBasePropertyKey<TKey> then return correct OrderItem
    var ordItem = await repOrderItem.GetModelByKeyAsync(2);
    
    var repOrder = repositoryManager.GenerateModelRepository<Order>();
    
    // Order not inherit from IBasePropertyKey<TKey> then Throw an ArgumentException
    var ord = await repOrder.GetModelByKeyAsync((2);
}

Pager

Since version 1.1 I have added a GetPagerModelAsync method, which returns a PagerModel<TModel> where TModel is the type model of the repository class. The PagerModel class is composed as follows:

int PageIndex --> index of the page 
int PageSize --> size of the page
long TotalCount --> number of total element without page
IEnumerable<TModel> ListModels --> list of Models found

Support

Any help is welcome. Bug insertion, new methods to implement, code improvement... And don't forget, if you want to support me

<a href="https://www.buymeacoffee.com/DenMic" target="_blank"><img src="https://cdn.buymeacoffee.com/buttons/v2/default-yellow.png" alt="Buy Me A Coffee" style="height: 60px !important;width: 217px !important;" ></a>