How should I implement sorting with Linq to Sql and ASP.NET MVC?

Question

I have an ASP.NET MVC application where I'm displaying a list of Products.

 // Product Controller
 public ActionResult List(string sort, int page)
 {
     var products = _productService.GetProducts(page, sort);
     return View(products);
 }

 // ProductService.cs
 public IEnumerable<Products> GetProducts(int pageIndex, string sort)
 {
     return _productRepository.GetProducts(pageIndex, 50, sort);
 }


 // ProductsRepository.cs
 public IEnumerable<Products> GetProducts(int pageIndex, int pageSize, string sort)
 {
     using(var db = new ShopDataContext())
     {
          return db.Products.OrderBy(??).Skip(pageIndex * pageSize).Take(pageSize).ToList();
     }
 }

I have a very simple service layer and repository.

How can I sort my Linq to SQL query by some arbitrary sort string/expression that I pull from the query string of my action?

/products?sort=hot&page=2

MJ Fathinia · Accepted Answer · 2011-08-22 04:17:40Z

2

You can use the Dynamic Linq for doing this and then you can simply make something like OrderBy("Hot ASC"). Check below link:

Dynamic LINQ

answered Aug 22, 2011 at 4:17

MJ Fathinia

2592 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

c0demaster · Accepted Answer · 2011-08-22 04:23:42Z

1

this page would help better

http://www.asp.net/entity-framework/tutorials/sorting-filtering-and-paging-with-the-entity-framework-in-an-asp-net-mvc-application

also you can use pagedlist.mvc for your paginated list

https://github.com/TroyGoode/PagedList

it is so simple and if you install the mvc version you just need to write on view this code then all pages and next buttons created automatically

@Html.PagedListPager((IPagedList)ViewBag.OnePageOfProducts, page => Url.Action("Index", new { page = page }))

if you get stack on any step please ask

answered Aug 22, 2011 at 4:23

c0demaster

7407 silver badges19 bronze badges

Collectives™ on Stack Overflow

How should I implement sorting with Linq to Sql and ASP.NET MVC?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related