NHibernate QueryOver具有子句
|
我想用QueryOver编写这样的查询，以便结果SQL类似于以下内容：
Select Bar, count(*) from Foo group by Bar having count(*) > 1
没有找到相关结果
已邀请:
2 个回复
掸牛浓疗
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));浅镁
应该使用QueryOver本质上是这样创建的：Session.QueryOver<Foo>() .Select(Projections.GroupProperty(Projections.Property<Foo>(foo => foo.Bar)), Projections.Count<Foo>(f => f.Id)) .Where(Restrictions.NotEqProperty(Projections.Count<Foo>(f => f.Id), Projections.Property<Foo>(foo => foo.Bar)));select Foo.Bar, COUNT(*) from Foo group by Foo.Bar where Foo.Bar <> COUNT(*)public class NonEqPropertyExpression : EqPropertyExpression { public NonEqPropertyExpression(IProjection lhsProjection, IProjection rhsProjection) : base(lhsProjection, rhsProjection) { } protected override string Op { get { return \"<>\"; } } }Session.QueryOver<Foo>() .Select(Projections.GroupProperty(Projections.Property<Foo>(foo => foo.Bar)), Projections.Count<Foo>(f => f.Id)) .Where(new NonEqPropertyExpression(Projections.Count<Foo>(f => f.Id), Projections.Property<Foo>(foo => foo.Bar)));