Also a good idea; though in this case I would shy away from it, since there are around 10k cats that are not fat and i only want to show the 15th or so page of them. I would like to stay away from getting back the whole list and paging / sorting it.
Hopefuly Fabio's suggestion of "sub-query using where" is what I was looking for. Thank you for this suggestion; I'll keep multi-queries in mind down the road; I remember reading about them in the docs. -Kelly Stuard On Jul 6, 2:50 pm, Tuna Toksoz <[email protected]> wrote: > I'd say use multiquery, first selects cats that are not domestic, second > selects domestic cats which are not fat. > You can then use list.AddRange(nondomestics); list.AddRange(nonfatdomestics) > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > > > On Mon, Jul 6, 2009 at 10:33 PM, kelly.stuard <[email protected]> wrote: > > > Hopefully someone on this list can help me out with this issue. > > > Taking the normal "Cat" strategy: > > * Base entity of Cat > > * Descendant of WildCat > > * Descendant of DomesticCat with property of Fat > > > I'd like to be able to perform a query that returns all Cats that are > > not Fat. Something like the following: > > from Cat cat > > where cat is 'DomesticCat' and cat.Fat = 0 > > > However, the property of Fat does not exist on Cat; only on the > > descendant class. I've tried various different ways but the only one > > I've had luck with is using SQL. I'd like to stay away from that, if > > possible; HQL just gives too much to give it up over something like > > this. > > > Hopefully someone has solved this problem before and can give some > > guidance. > > > Thanks, > > Kelly- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
