Something like:
DetachedCriteria.For<Company>()
  .CreateCriteria("CompanyGroup", "cg")
  .AddOrer(Order.Asc("cg.Name")

On Wed, Oct 29, 2008 at 12:21 AM, Bart Reyserhove <[EMAIL PROTECTED]
> wrote:

> I have an domain object: Company.
> 1) Company has an association with an Address
> 2) Company also has an association with CompanyGroup
>
> I am trying to use the ICriteria stuff to create a query that retrieves all
> Companies where Address.Country = 'Belgium' and I want to order this result
> on the name property of CompanyGroup.
>
> The filter is no problem at all. I can easily find all Belgian companies,
> but sorting them on another association seems really difficult at first
> sight.
>
> How can I approach this?
>
> Thanks,
>
> Bart
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to