使用 LINQ 的自定义投影运算符

我们创建了自定义存储库类来从实体框架上下文中检索对象。Get 方法始终返回整个对象。

我希望包括项目操作员选择作为参数。这样我们就可以从外部传递需要选择的内容，SQL查询将更有效率。可行吗？

public class GenericRepository<TEntity> where TEntity : class
{
    internal DbContext context;        
    public IEnumerable<TEntity> Get(
        Expression<Func<TEntity, bool>> filter = null,
        Func<IQueryable<TEntity>, IOrderedQueryable<TEntity>> orderBy = null)
    {
        IQueryable<TEntity> query = dbSet;
        if (filter != null)
        {
            query = query.Where(filter);
        }
        if (orderBy != null)
        {
            return orderBy(query).ToList();
        }
        else
        {
            return query.ToList();
        }
    }
}

private static PropertyInfo ResolveProperty<T>(Expression<Func<T, object>> property) where T : class
    {
        MemberExpression member;
        UnaryExpression body = property.Body as UnaryExpression;
        if (body != null)
        {
            member = (MemberExpression)body.Operand;
        }
        else
        {
            member = (MemberExpression)property.Body;
        }
        PropertyInfo info = (PropertyInfo)(member).Member;
        return info;
    }