from Company c join c.Address a where a.City like 'bru%' order by
c.CompanyGroup.Name
2008/10/29 Bart Reyserhove <[EMAIL PROTECTED]>
> Yeah I know that is the easy part, what I am trying to do is something
> along the lines of:
>
> DetachedCriteria.For<Company>()
> .CreateCriteria("Address").Add(Restrictions.Like("City","bru")
> .CreateCriteria("CompanyGroup","cg").AddOrder(Order.Asc("cg.Name")
>
> The problem is of course that CompanyGroup is an association of Company and
> not of Address.
>
>
> On Wed, Oct 29, 2008 at 4:56 AM, Ayende Rahien <[EMAIL PROTECTED]> wrote:
>
>> 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
>>>
>>>
>>>
>>
>>
>>
>
> >
>
--
Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
