NHibernate Intersection

Question

How can I do the intersection in nhibernate?

select enterprise.Id 
from Enterprises

intersect

select enterpiseID 
from vEnterprise

Answer 1

http://www.hibernate.org/117.html#A21

It does not currently support merging or overlap.

_

You can use a named SQL query and do a join in raw SQL. NHibernate will be able to populate entity instances from the sql query and return them as the result of the query. See here and here .