NHibernate intersection

How can i do intersection in nhibernate? is

sele开发者_如何学JAVAct enterprise.Id 
from Enterprises

intersect

select enterpiseID 
from vEnterprise

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.