如何使用字符串来创建EF顺序的表达式？ [英] How to use a string to create a EF order by expression?

问题描述

我正在尝试这个转换

"Address.Street" => (p) => p.Address.Street
"Name" => (p) => p.Name

我能够找到一种通过使用反射表达式生成顺序的方法，但它赢了对于单个属性级别，不能像 Address.Street 一样工作。

I was able to find a method to generate an order by expression using reflection but it won't work for complex sort as Address.Street since works for a single property level.

有没有办法去做这个？我已经看到我编译了lambda表达式，但是我无法理解如何使它在这种情况下工作。

Is there a way to do this? I've seen that I compile lambda expressions but I couldn't understand how to make it work for this case.

推荐答案

创建一个表达式并不困难，但棘手的部分是如何将它绑定到相应的 OrderBy（Descending） / ThenBy（Descendig）方法，当您不知道属性的类型（因此选择器表达式结果的类型）。

Creating an expression is not hard, but the tricky part is how to bind it to the corresponding OrderBy(Descending) / ThenBy(Descendig) methods when you don't know the type of the property (hence the type of the selector expression result).

这是封装在自定义扩展中的所有内容方法：

Here is all that encapsulated in a custom extension method:

public static partial class QueryableExtensions
{
    public static IOrderedQueryable<T> OrderByMember<T>(this IQueryable<T> source, string memberPath)
    {
        return source.OrderByMemberUsing(memberPath, "OrderBy");
    }
    public static IOrderedQueryable<T> OrderByMemberDescending<T>(this IQueryable<T> source, string memberPath)
    {
        return source.OrderByMemberUsing(memberPath, "OrderByDescending");
    }
    public static IOrderedQueryable<T> ThenByMember<T>(this IOrderedQueryable<T> source, string memberPath)
    {
        return source.OrderByMemberUsing(memberPath, "ThenBy");
    }
    public static IOrderedQueryable<T> ThenByMemberDescending<T>(this IOrderedQueryable<T> source, string memberPath)
    {
        return source.OrderByMemberUsing(memberPath, "ThenByDescending");
    }
    private static IOrderedQueryable<T> OrderByMemberUsing<T>(this IQueryable<T> source, string memberPath, string method)
    {
        var parameter = Expression.Parameter(typeof(T), "item");
        var member = memberPath.Split('.')
            .Aggregate((Expression)parameter, Expression.PropertyOrField);
        var keySelector = Expression.Lambda(member, parameter);
        var methodCall = Expression.Call(
            typeof(Queryable), method, new[] { parameter.Type, member.Type },
            source.Expression, Expression.Quote(keySelector));
        return (IOrderedQueryable<T>)source.Provider.CreateQuery(methodCall);
    }

这篇关于如何使用字符串来创建EF顺序的表达式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！