使用 nhibernate 进行划分会导致“无法确定成员来自”。

发布于 2024-08-18 04:45:21 字数 588 浏览 4 评论 0原文

这可能很简单，但我似乎缺乏一些关于 nhibernate 如何工作的知识。这是我的代码：

ICriteria query = Session.CreateCriteria<TblProjectCategory>();
query = query.CreateCriteria<TblProjectCategory>(x => x.TblProjects)
    .Add<TblProject>(x => x.FldCurrentFunding != 0m)
    .Add<TblProject>(x => x.FldCurrentFunding / x.FldFundingGoal >= .8m)
    .SetResultTransformer(
        new NHibernate.Transform.DistinctRootEntityResultTransformer());

return query.List<TblProjectCategory>();

我得到的错误是：“无法确定 (x.FldCurrentFunding / x.FldFundingGoal) 的成员”

原文

This is probably something simple but I seem to be lacking some knowledge of how nhibernate works. This is my code:

ICriteria query = Session.CreateCriteria<TblProjectCategory>();
query = query.CreateCriteria<TblProjectCategory>(x => x.TblProjects)
    .Add<TblProject>(x => x.FldCurrentFunding != 0m)
    .Add<TblProject>(x => x.FldCurrentFunding / x.FldFundingGoal >= .8m)
    .SetResultTransformer(
        new NHibernate.Transform.DistinctRootEntityResultTransformer());

return query.List<TblProjectCategory>();

The resulting error I get is: "Could not determine member from (x.FldCurrentFunding / x.FldFundingGoal)"

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

此生挚爱伱 2024-08-25 04:45:21

NHibernate 无法将表达式转换为 sql 语句，因为它不知道如何处理 x.FldCurrentFunding / x.FldFundingGoal。解决方案是将其重写为这样的表达式：

ISQLFunction sqlDiv = new VarArgsSQLFunction("(", "/", ")");
(...)
   .Add(
    Expression.Ge(
        Projections.SqlFunction(
            sqlDiv, 
            NHibernateUtil.Double,
            Projections.Property("FldCurrentFunding"),
            Projections.Property("FldCurrentGoal")
        ),
        0.8m 
    )
    )
(...)

我希望这能给您一些指导

NHibernate is not able to translate the expression into a sql statement because is does not know what to do with x.FldCurrentFunding / x.FldFundingGoal. The solution is rewriting this to an expression like:

ISQLFunction sqlDiv = new VarArgsSQLFunction("(", "/", ")");
(...)
   .Add(
    Expression.Ge(
        Projections.SqlFunction(
            sqlDiv, 
            NHibernateUtil.Double,
            Projections.Property("FldCurrentFunding"),
            Projections.Property("FldCurrentGoal")
        ),
        0.8m 
    )
    )
(...)

I hope this will give you some directions

回复收藏 0 原文

~没有更多了~