Can I define Default Sort order in LinQ

If I have a nested ListView, and I’m calling a related table in LinQ, how do I sort it, without resorting to the ItemDataBound event of the parent?

Pseudo Code (UPDATED WITH SOLUTION):

<asp:ListView ID="lv" runat="server" OnItemDataBound="lv_ItemDataBound" >
   <LayoutTemplate>
      <!-- Product Category Stuff --> 
      <asp:PlaceHolder Id="itemPlaceholder" runat="server"></asp:PlaceHolder>
   </LayoutTemplate>

   <ItemTemplate>
      <asp:ListView ID="lvInner" runat="server" DataSource='<%# <%# ((Category)Container.DataItem).Products.OrderBy(p => p.Description) %> %>'>
         <LayoutTemplate>
            <ul>
               <asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
            </ul>
         </LayoutTemplate>
         <ItemTemplate>
            <li>Item Stuff</li>
         </ItemTemplate>
      </asp:ListView>
   </ItemTemplate>
</asp:ListView>

Perhaps the method is deceptively simple, but I want the inner Products to be sorted by a field. I can’t see a way to do it declaratively as LinQ creates this Query on the fly, if I’m not mistaken, and doesn’t do sorting.

Any thoughts?

UPDATE

Updated the Example to the following:

<%# ((Category)Container.DataItem).Products.OrderBy(p => p.Description) %>

Hope it helps someone else!

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

My assumption is that Products is an IEnumerable<Product> (or IQueryable). If that is the case, why not just add the OrderBy method to the evaluation, like so:

<%# Eval("Products.OrderBy(p => p.FieldToSortOn)") %>

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0