HQL operator |
QBC operator |
Meaning |
= |
Restrictions.eq () |
equals equal |
<> |
Restrictions.ne () |
Not equal to not equal |
> |
RESTRICTIONS.GT () |
Greater than greater than |
>= |
Restrictions.ge () |
Greater than or equal to greater than or equal |
< |
Restrictions.lt () |
Less than |
<= |
Restrictions.le () |
Less than or equal to than or equal |
Is null |
Restrictions.isnull () |
equals null value |
is NOT NULL |
Restrictions.isnotnull () |
Non-null value |
Like |
Restrictions.like () |
String pattern Matching |
and |
Restrictions.and () |
Logic and |
and |
Restrictions.conjunction () |
Logic and |
Or |
Restrictions.or () |
Logical OR |
Or |
Restrictions.disjunction () |
Logical OR |
Not |
Restrictions.not () |
Logical Non- |
In ( list ) |
Restrictions.in () |
equals one of the values in the list |
Not in ( list ) |
Restrictions.not (restrictions.in ()) |
is not equal to any one of the values in the list |
Between X and Y |
Restrictions.between () |
Any value in the closed interval xy |
Not between X and Y |
Restrictions.not (restrictions. Between ()) |
Less than value x or greater than value Y |
Nhibernate Query by criteria criteria