NHibernate:如何通过引用实体的属性对集合进行排序 [英] NHibernate: how to sort a collection by a property of a referenced entity

问题描述

我想按Retailer.Name对CampaignRetailers进行排序.但是，零售商是CampaignRetailers上的参考实体.我已经尝试过order-by="Retailer.Name".这种分类可能吗?

I would like to to sort CampaignRetailers by Retailer.Name. However Retailer is a referenced entity on CampaignRetailers. I've tried order-by="Retailer.Name". Is this kind of sorting possible?

<class name="Campaign" table="Campaign">
  <id name="Id">
    <generator class="identity"/>
  </id>
  <set name="CampaignRetailers" table="CampaignRetailers"
       cascade="all-delete-orphan" inverse="true" order-by="Retailer.Name">
    <key column="CampaignId" not-null="true" />
    <one-to-many class="CampaignRetailer" />
  </set>
</class>

<class name="CampaignRetailer" table="CampaignRetailers">
  <id name="Id">
    <generator class="identity"/>
  </id> 
  <many-to-one name="Campaign" column="CampaignId" />
  <many-to-one name="Retailer" column="RetailerId" />
</class>

推荐答案

这是不可能的.

请改用客户端临时排序.例如:

Use client-side adhoc sorting instead. For example:

sortedCampaignRetailers = campaign.CampaignRetailers
                                  .OrderBy(x => x.Retailer.Name);

这篇关于NHibernate:如何通过引用实体的属性对集合进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！