How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?

by

We did something similar (not 100% the same, but similar) in a LINQ to SQL project. Here’s the code:

public static IQueryable<T> OrderBy<T>(this IQueryable<T> source, string ordering, params object[] values) {
    var type = typeof(T);
    var property = type.GetProperty(ordering);
    var parameter = Expression.Parameter(type, "p");
    var propertyAccess = Expression.MakeMemberAccess(parameter, property);
    var orderByExp = Expression.Lambda(propertyAccess, parameter);
    MethodCallExpression resultExp = Expression.Call(typeof(Queryable), "OrderBy", new Type[] { type, property.PropertyType }, source.Expression, Expression.Quote(orderByExp));
    return source.Provider.CreateQuery<T>(resultExp);
}

We didn’t actually use a generic, we had a known class, but it should work on a generic (I’ve put the generic placeholder where it should be).

Edit: For descending order, pass in OrderByDescending instead of “OrderBy”:

MethodCallExpression resultExp = Expression.Call(typeof(Queryable), "OrderByDescending", new Type[] { type, property.PropertyType }, source.Expression, Expression.Quote(orderByExp));

More Related Contents:

  1. Linq: help me to make this work
  2. How to create LINQ Expression Tree to select an anonymous type
  3. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  4. Entity Framework/Linq EXpression converting from string to int
  5. LINQ to Entities only supports casting EDM primitive or enumeration types with IEntity interface
  6. Filter/Search using Multiple Fields – ASP.NET MVC
  7. How to convert an expression tree to a partial SQL query?
  8. Generate EF orderby expression by string [duplicate]
  9. How do I create an expression tree calling IEnumerable.Any(…)?
  10. Internal .NET Framework Data Provider error 1025
  11. Join and Include in Entity Framework
  12. Max return value if empty query
  13. Remove item from list based on condition
  14. How to do an “in” query in entity framework?
  15. How does PredicateBuilder work
  16. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  17. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  18. How to include() nested child entity in linq
  19. Should the order of LINQ query clauses affect Entity Framework performance?
  20. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  21. LINQ Query to Convert string to datetime
  22. Get all checked nodes of a treeview
  23. How to flatten tree via LINQ?
  24. Using LINQ to remove elements from a List
  25. The type of one of the expressions in the join clause is incorrect in Entity Framework
  26. How to Bulk Update records in Entity Framework?
  27. EF 6 – How to correctly perform parallel queries
  28. DISTINCT() and ORDERBY issue
  29. Can I LINQ a JSON?
  30. Entity framework raw SQL Query

Leave a Comment