YouBIM.Common.Repository.Lib.EntityFramework 2.0.0

YouBIM.Common.Repository.Lib

Description

This repository contains two class libraries that serve as base repositories for Entity Framework Core and MongoDB.

Requirements

.NET Core 6 Entity Framework Core MongoDB

Installation

dotnet restore

Usage

Entity Framework Core

To use the Entity Framework Core base repository, simply inherit from the 'BaseRepository<TEntity>' class.

using YouBIM.Common.Repository.Lib.EntityFramework;

public class UserRepository : BaseRepository<User>
{
    public UserRepository(DbContext context) : base(context)
    {
    }
}

New Methods params

• GetQuery(Expression<Func<TEntity, bool>> filter, Func<IQueryable<TEntity>, IOrderedQueryable<TEntity>> orderBy, params Expression<Func<TEntity, object>>[] includes)

Advanced Usage with includesProperties in V2

You can use the GetQuery method to retrieve a queryable object with filtering, ordering, and eager loading of related entities. Here's an example:

using YouBIM.Common.Repository.Lib.EntityFramework;
using System.Linq.Expressions;

public class UserService
{
    private readonly UserRepository _userRepository;

    public UserService(UserRepository userRepository)
    {
        _userRepository = userRepository;
    }

    public void GetUserDetails()
    {
        // first option
        Expression<Func<User, bool>> filter = user => user.IsActive;
        Func<IQueryable<User>, IOrderedQueryable<User>> orderBy = q => q.OrderBy(u => u.LastName);
        Expression<Func<User, object>>[] includes = new Expression<Func<User, object>>[]
        {
			w => w.WorkorderLocations, // Includes
			w => w.WorkorderLocations.Select(wl => wl.Location), // Includes nested
			w => w.WorkorderLocations.Select(wl => wl.Location.ApplicationConfigsLocations), // Includes nested
			w => w.WorkorderLocations.Select(wl => wl.Location.ApplicationConfigsLocations.Select(acl => acl.ApplicationConfig)), // Includes nested
        };

        var query = _userRepository.GetQuery(filter, orderBy, includes);

        //second option
        var query2 = _userRepository.GetQuery(
                             user => user.IsActive, // filter
                             u => u.LastName, // ordeBy
                             w => w.WorkorderLocations, // Includes
							 w => w.WorkorderLocations.Select(wl => wl.Location), // Includes nested
							 w => w.WorkorderLocations.Select(wl => wl.Location.ApplicationConfigsLocations), // Includes nested
							 w => w.WorkorderLocations.Select(wl => wl.Location.ApplicationConfigsLocations.Select(acl => acl.ApplicationConfig)), // Includes nested
                            ); 
    }
}

In this example, we're using the GetQuery method to:

• Filter active users (filter)
• Order them by their last name (orderBy)
• Eagerly load their Address and Orders related entities (includes).

Note: The includes parameter now uses strongly-typed expressions instead of string-based navigation properties, providing better type safety and refactoring support.