NHibernate - 哪里存在(X)

Question

我有下表(简化):

Product(Id, Name)
OrderItem(Id, ProductId)

...映射到以下类:

Product {Id, Name}
OrderItem {Id, Product (many-to-one)}

我需要 (N)Hibernate 语法来检索出现在订单中的产品。
SQL 类似于:

select *
from   Product
where  exists (
       select *
       from   OrderItem
       where  OrderItem.ProductId = Product.Id)

如何创建条件？

Answer 1

事实证明这很容易......

var query = session.CreateQuery(
            "select distinct oi.Product from OrderItem oi");
return query.List<Product>();