Upgrading to the latest version of NHibernate may be an option if that would solve my problem in a relatively staightforward manner. Do you know how to do this in NHibernate 2.1.0 GA?
On Sep 21, 9:39 am, Tuna Toksoz <[email protected]> wrote: > I think this is a feature added in 2.0+ > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > On Thu, Sep 17, 2009 at 4:57 PM, paper1337 <[email protected]> wrote: > > > Using the Criteria API, I want to create a query that generates SQL > > like: > > > SELECT BranchID > > > FROM FIServiceLocation > > > ORDER BY (SELECT InstitutionName FROM Institution WHERE > > Institution.InstitutionID=FIServiceLocation.InstitutionID) > > > This is just an example to reflect my requirements, but hopefully it > > gets my point across. Effectively I want to order my results by the > > results of a subquery. If anyone has any advice on how to go about > > this (already tried banging my head against the wall...does not seem > > to be working), it would be much appreciated. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
