Hi,


I'm thinking of using nhibernate over crud store procedures, is it possible to get a collection of objects from a join query without returning the data for the tables in the join.

e.g. I want orders between dates of abc and def for customers with addresses that have a postcode of xyz

or
select o.* from orders o inner join customers c on o.customerid = c.id inner join address a on c.addressid = address.id where o.orderdate between abc and def and a.postcode = xyz

I don't want to have to load all the customer and address information.