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 -~----------~----~----~----~------~----~------~--~---
