How to use Dynamic LINQ in MVC4?

asp.net-mvc-4 c# dynamic-linq linq

Question

This is the default action from the "View" of my MVC4 application.

public ActionResult Index(string sort = "R_ResDate", 
                          string sortdir = "DESC", 
                          int page = 1)
{
    List<Result> results = modRes.Results.ToList();

    var results = from r in results
                  orderby r.R_ResultDate descending
                  select r;

    return View(results);
}

Where modRes is a Model class,

I wanted to use the sort column, sortDir, and page arguments in the dynamic linq to derive the results.

Any help would be appreciated.

1
0
2/25/2014 5:39:36 AM

Accepted Answer

You can use this code for paging and sorting data:

var p = Expression.Parameter(typeof(Model));
var sortByFunc = Expression.Lambda<Func<Model, object>>(Expression.TypeAs(Expression.Property(p, sortByKey), typeof(object)), p).Compile();

var items = from r in modRes.Results
            orderby r.R_ResultDate descending
            select r;
var orderedItems = sortByAsc 
      ? items.OrderBy(sortByFunc) 
      : items.OrderByDescending(sortByFunc);
var results = orderedItems.Skip((pageIndex - 1) * pageSize).Take(pageSize);

return View(results);

Also, you shouldn't to call ToList method on modRes.Results query, because in this case will be loaded all data, when only data for one page should be loaded.

-1
2/25/2014 5:43:17 AM


Related Questions





Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow