named query in NHibernate with not equal operator

Question

NHibernate throw exception with sql server not equal to operator <>.

<sql-query name="Select">
    <return alias="OrderStock" class="OrderStock"/>
select * from OrderStock WHERE dh.DATE_UNLOADED <> '1753-01-01'
</sql-query>

Name cannot begin with the '>' character

Answer 1

We can escape symbols <> with <> like this:

<sql-query name="Select">
    <return alias="OrderStock" class="OrderStock"/>
select * from OrderStock WHERE dh.DATE_UNLOADED &lt;&gt; '1753-01-01'
</sql-query>

Or we can use xml raw text escaping with <![CDATA[ .... ]]>:

<sql-query name="Select">
    <return alias="OrderStock" class="OrderStock"/>
<![CDATA[
select * from OrderStock WHERE dh.DATE_UNLOADED <> '1753-01-01'
]]>
</sql-query>