LINQ dynamic group on demand in ASP.NET MVC

Question

I am wondering how best to solve this, because what works fine for my hard-coded column in my view now - I wonder how I can expand it to allow the column to be dynamic.

CONTROLLER:

var dc = new DataContextDC();
return View(dc.items.Where(i=>i.IsPublic == true));

VIEW:

<% foreach (var grp in Model.GroupBy(s => s.GroupColumn)) { %>
    <%= Html.Encode(grp.Key) %>
    <% foreach (var item in grp) { %>
        <%= Html.Encode(item.Title) %>
    <% } %>
<% } %>

As indicated, the goal is to allow the user to choose which column replaces the "GroupColumn" above. I would like not to add external libraries, etc.

I see the use of reflection (slow but completely dynamic), or since this is one view in my application, I just duplicate the above code for each column in the database and then put the switch statement on it (fast and dirty, but efficient)

Answer 1

, , Linq Dynamic Query, # Linq, , :

var groups = Model.GroupBy("SomeColumn, SomeOtherColumn")

..., , - , , , - , - , ( ParseException, ).

Html.Encode, - - { ID = 1, Name = Test }. , , Reflection .

: , , , .

Answer 2

Dynamic Linq:

http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx