Sorting Table By Its Groupname, Where Data Is Fetched From Database Using Mvc 2.0

I need to have a View which looks something like this: [+] Group Name1 //this is supposed to be an accordion menu Sub Name| Scale1| Scale2| Scale3|

Solution 1:

So if you just need to to always sort by GroupName then in your business layer you could just use linq to do something like

viewModel.skills = skills.OrderBy(x => x.GroupName)