Thanks for giving that example. One of my pet-peeves with AR/NH is that the
criterion stuff works great for the simple cases when you're querying against
properties on the object itself but I often (read: almost always) need to look
at properties on sub-objects too. I always end up just writing a full fledged
HQL query. I've always wish that this would just work:
class Person
{
public Department { get; set; }
}
class Department
{
public Name { get; set; }
}
// find all the people who work in the Accounting department
Person.FindAllByProperty("Deptartment.Name", "Accounting");
----- Original Message ----
From: Gauthier Segay <[EMAIL PROTECTED]>
To: Castle Project Users <[email protected]>
Sent: Sunday, September 7, 2008 9:41:25 AM
Subject: Re: AR/NH: How to sort by a column in a related table?
You must add alias to the joined table:
class Order{Customer Customer {get;}}
class Customer{string Name {get;}}
orderCriteria.AddAlias("Customer","c").AddOrder("c.Name")
On 7 sep, 14:06, goodwill <[EMAIL PROTECTED]> wrote:
> As title, like if I want to sort staff records by department name with
> certain staffs joining after a date.
>
> If I write Order.Asc("Dept.Name") it just won't work.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" 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/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
