is it possible to use custome stored procedure approach in cascade object operation fetch ?
Let's say I have one manufacturer class and it contains collection of Order(Order is another class).Now my question is when I fetch the manufacturer object using nHibernate and I want to fetch the OrderList using manufactureObject.OrderList. When I say manufactureObject.OrderList, nHibernate should invoke stored procedure containing certain parameters and the result will be like Order Object which contains collection of Orders.