I've got a search function in my program that is able to build a sql statement, which, when ran, will return a list of ID's (integers). I want to fetch (with paging) records from a table where the ID is on this list.
What is the best way to do this? It seems like it would be nice and easy if NHibernate allow you to manually specify a subquery's SQL for Subqueries.PropertyIn(), but it doesn't, and there doesn't seem to be a way to wrap a sql string in a detached criteria. Any suggestions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---