NHibernate和MySql关键字 [英] NHibernate and MySql Keywords

问题描述

为什么Nibernate HQL无法处理以下查询:

Why Nibernate HQL can not handle the following query:

from Deal D where (D.ApprovalDate + INTERVAL 1 Year) < current_timestamp() <  (D.RenewalDate + INTERVAL -1 Year) 

知道INTERVAL和YEAR是MySQL中的关键字，因此这是在Hql中混合Sql的一种方式(除非Hql可以像这样处理日期函数，但我不知道).该方言为 MySQLDialect

knowing that INTERVAL and YEAR are keywords in MySQL, so this is kind of mixing Sql within Hql (unless Hql can handle date functions like so and I don't know) . The dialect is MySQLDialect

执行此查询非常有效

  SELECT '2005-01-01' + INTERVAL 1 Year;

推荐答案

您可以使用条件查询在查询中直接传递Sql.像这样

You can pass the Sql directly in the query using Criteria Query. Something like this

Session.CreateCriteria<Deal>()
.Add(Restrictions.Sql(D.ApprovalDate + " INTERVAL 1 Year < current_timestamp() < " + D.RenewalDate + " INTERVAL -1 Year")

Restrictions.Sql会将您提供的所有内容直接以sql的形式传递给数据库.

The Restrictions.Sql will pass whatever you give it directly to the database as sql.

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