将 SQL 查询转换为 Nhibernate 条件

Question

My SQL query：

select [CompanyId] 
from dbo.Bussiness_Company
where [BussinessId] in (11,12,13)
group by [CompanyId]
having COUNT(distinct [BussinessId])=3

解释：我有一张桌子Bussiness_Company桌子：

Bussiness_Company

编号*

BussinessId

公司编号

我的数据：

Id

---------BussinessId------------CompanyId

1----------10---------------------100

2----------11---------------------100

100----------12---------------------

雷索尔查询

公司编号

100

• 谢谢任何嘶吼！

斯洛夫德：

这是我的代码：

DetachedCriteria detachedCriteria = DetachedCriteria.For<BussinessCompany>();
 detachedCriteria.SetProjection(Projections.Property("Company"));
 detachedCriteria.SetProjection(Projections.GroupProperty("Company"));
 Disjunction disjunction = Restrictions.Disjunction();
 foreach (Bussiness bussiness in list)
 {
   disjunction.Add(Restrictions.Eq("Bussiness", bussiness ));
 }                  detachedCriteria.Add(disjunction).Add(Restrictions.Eq(Projections.CountDistinct<BussinessCompany>(m => m.Bussiness), list.Count));
 IList<Sonomi.Core.BusinessObjects.Bussiness> bussiness =
                    bussinessUnitManager.CreateCriteria().Add(Subqueries.PropertyIn("Id", detachedCriteria)).List
 <Sonomi.Core.BusinessObjects.BussinessUnit>();
 dgrCer.DataSource = bussiness;
 dgrCer.DataBind();

Answer 1

您可以尝试这样的 QueryOver 代码：

var bussinessIdCount = 3;
var bussinessIds = new[] { 11, 12, 13 };
Bussiness_Company bussinessCompany = null;
session.QueryOver(() => bussinessCompany)
  .WhereRestrictionOn(() => bussinessCompany.BussinessId).IsIn(bussinessIds)
  .Select(Projections.Group(Projections.Property(() => bussinessCompany.CompanyId)))
  .Where(Restrictions.Gt(Projections.CountDistinct(() => bussinessCompany.BussinessId), bussinessIdCount));