I want to know what is the best way to implement a product list page (category page like Books) in ASP .NET MVC that loads product list from Database and list it to users. There a few points to consider it:
- I'm using a recommend-er system that defines which orders of products to be listed in product list view
- I have also another sorting defined per category in product list that defined by site admin
- User can change default sort by newest, bestselling,... and I want to have this sorting in-place with effect of Recommend-er system.
- To improve performance I'm using caching (output cache, webcache) and I'm not sure how to keep caching with my scenario