NHibernate 使用 QueryOver 和 WHERE IN [英] NHibernate using QueryOver with WHERE IN

问题描述

我会像这样创建一个 QueryOver

I would create a QueryOver like this

SELECT *
FROM Table
WHERE Field IN (1,2,3,4,5)

我尝试过 Contains 方法，但遇到了异常

I've tried with Contains method but I've encountered the Exception

System.Exception:无法识别的方法调用:System.String:Boolean Contains(System.String)"

"System.Exception: Unrecognised method call: System.String:Boolean Contains(System.String)"

这是我的代码

var qOver = _HibSession.QueryOver<MyModel>(() => baseModel)                                                                
  .JoinAlias(() => baseModel.Submodels, () => subModels)
  .Where(() => subModels.ID.Contains(IDsSubModels))
  .List<MyModel>();

推荐答案

我找到了解决方案！！:-)

I've found the solution!! :-)

var qOver = _HibSession.QueryOver<MyModel>(() => baseModel)
    .JoinAlias(() => baseModel.Submodels, () => subModels)
    .WhereRestrictionOn(() => subModels.ID).IsIn(IDsSubModels)
    .List<MyModel>();

这篇关于NHibernate 使用 QueryOver 和 WHERE IN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！