排序内蒙古器使用LINQ查询 [英] Sort Inner Repeater with LINQ query

问题描述

我试图列出一组协会，在每个关联是分配到协会部件。这份名单将包括公会名称和分配给它的任何部件。美中不足的是，内部部件列表需要由DisplaySequence进行排序。

I am attempting to list a group of Associations, within each association is a 'widget' that is assigned to the association. The list will include the Association name and any widget assigned to it. The catch is that the inner widget list needs to be sorted by DisplaySequence.

EDMX型号如下图：

EDMX Model Below:

简体直放站加价

<asp:Repeater ID="rptAssociations" runat="server">
    <ItemTemplate>      
        <div data-type="assn" id="<%# ((Association)Container.DataItem).AssociationID %>">
            <h3 style="margin-top:15px;"><%# ((Association)Container.DataItem).Acronym %> - <%# ((Association)Container.DataItem).Name %></h3> 
            <asp:Repeater runat="server" ID="rptWidgets" DataSource="<%# ((Association)Container.DataItem).AssociationWidgets %>" >
                <HeaderTemplate>                
                    <ul class="WidgetList">
                </HeaderTemplate>
                <ItemTemplate>
                    <li id="<%# ((AssociationWidget)Container.DataItem).DisplaySequence %>"><%# ((AssociationWidget)Container.DataItem).Widget.Name %></li>
                </ItemTemplate>
                <FooterTemplate>
                    </ul>
                </FooterTemplate>
            </asp:Repeater>
        </div>      
    </ItemTemplate>
</asp:Repeater>

当前查询

var associations = (from a in 
    context.Associations.Include("AssociationWidgets")
                        .Include("AssociationWidgets.Widget")
    orderby a.Acronym
    select a).ToList();

rptAssociations.DataSource = associations;
rptAssociations.DataBind();

我目前能得到我正在寻找与我现在的设置数据。我在寻找最有效的方法来获得同样的数据，但是，具有正确的显示顺序列出的小工具。

I am currently able to get the data that I'm looking for with the setup that I have now. I am looking for the most efficient approach to getting this same data, however, having the Widgets listed in the correct display order.

有不同的方法来LINQ查询我应该采取？

Is there a different approach to the linq query I should take?

推荐答案

我会处理这像这样（未经）：

I would approach this like this (untested):

var associations = 
    context.Associations.Select( a => 
       new {
          //... specific properties you need 
          AssociationId = a.AssociationId,
          Name = a.Name,
          ... etc
          Widgets = a.AssociateWidgets.OrderBy(aw => aw.DisplaySequence)
                                      .Select(aw => aw.Widget)
       }
    );

在这里，你会得到匿名类型的集合。你可以用一个具体的类型，如

Here you'll get a collection of anonymous types. You can use a concrete type such as

public class AssociationInfo
{
    public string Name {get;set;}
    ...
    public IEnumerable<Widget> Widgets{ get;set; }
}

如果有必要更换新{'与新AssociationInfo {'

这篇关于排序内蒙古器使用LINQ查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！