How to use a string to create a EF order by expression?

by

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);
    }

More Related Contents:

  1. Linq: help me to make this work
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. Bulk-deleting in LINQ to Entities
  4. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  5. The type of one of the expressions in the join clause is incorrect in Entity Framework
  6. Entity framework left join
  7. Why doesn’t Include have any effect?
  8. Value cannot be null. Parameter name: source
  9. Recursive Hierarchy – Recursive Query using Linq
  10. Filter/Search using Multiple Fields – ASP.NET MVC
  11. Linq to EntityFramework DateTime
  12. LINQ to SQL multiple tables left outer join
  13. How to Bulk Update records in Entity Framework?
  14. The result of a query cannot be enumerated more than once
  15. Entity Framework. Delete all rows in table
  16. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  17. Entity-framework code is slow when using Include() many times
  18. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  19. The operation cannot be completed because the DbContext has been disposed using MVC 4
  20. Linq to Entity Join table with multiple OR conditions
  21. Export Model to DataTable
  22. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  23. Simulating Cross Context Joins–LINQ/C#
  24. Max return value if empty query
  25. Check if list contains item from other list in EntityFramework
  26. How to do an “in” query in entity framework?
  27. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  28. How to include() nested child entity in linq
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. LINQ Query to Convert string to datetime

Leave a Comment