Hi Joe, In the current version of NH you can pass a Projection to the AddOrder bit. Give it a try.
Hope this helps, Jarda On Nov 19, 3:11 am, joe <[EMAIL PROTECTED]> wrote: > Hi. > > I'm using the criteria to create composable queries. > I found it very clean and reusable but stuggle with advanced queries. > I would like to sort my criteria api with custom sql, is it possible ? > Ideally I would like to have a formula property, and sort on that > formula. > The problem is that I don't want this property to be eager loaded > because the formula involves several joins. > As far as I know there is no lazy property loading supported (NH 1.2) > and the criteria api AddOrder method only accept an association path > (but no custom sql overload). > > Any advice would be appreciated. > > Thank you. > > Joe. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
