NHibernate QueryOver Have 子句

Question

我想用 QueryOver 编写这样一个查询，以便结果 SQL 将类似于以下内容:

Select Bar, count(*) from Foo group by Bar having count(*) > 1

我该怎么做 ？

Answer 1

我想你只会使用 Where 方法

Session.QueryOver<Foo>()
    .Select(Projections.GroupProperty(Projections.Property<Foo>(foo => foo.Bar)),
            Projections.Count<Foo>(f => f.Id))
    .Where(Restrictions.Gt(Projections.Count<Foo>(f => f.Id), 1));