NHibernate intersection

Question

Hi, How can i do intersection in nhibernate? is

select enterprise.Id 
from Enterprises

intersect

select enterpiseID 
from vEnterprise

Answer 1

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

It doesn't currently support union or intersect.

_

You could use a named sql-query and do the union in raw SQL. NHibernate will be able to populate entity instances from the sql-query and return those as the query result. See here and here.