Apologies for my ignorance, i've had a look through the evaluation faq and a few others faqs and various other getting started and other pages.
but couldn't see the answer, and thought my question is so simple someone should know right away..?

I'm looking at using nhibernate for a new project and wanted to know
if you can map partial resultsets, i read somewhere that its v difficult with nhibernate to map to sql server views.

but for e.g. if i had a person table that contained customers, prospective customers and contacts, could i map/create collections of customers,prospective customers and contacts even though they all reside in the same table..?

and if so what would the performance be like..?

thanks,

sam.