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

Reply via email to