I have a stored procedure that returns a list of object ids for a specific type. Is there any way to issue one query with NHibernate to return the objects matching the Id's returned by the stored procedure?

For example say that the sproc returns Ids 5, 7, 8, 22, and 56 for type of Employee. Now I need to get a collection of employees that match the same ids.

Thanks for any help.

You can try:


I don't know the exact syntax...

thanks. Seems like it should work.