Can we use 'is NULL' in select query

Chaitanya kumar · **Joined:** Thu Jul 31, 2008 2:09 am **Posts:** 2

Hi

Please clarify whether I am right or wrong in this below query

session.Find("SELECT FROM table1 AS t1 WHERE t1.column1 is not NULL ORDER BY t1.column2")

I am not getting data with this query ,Please help me out for this.

wolli · **Posted:** Thu Jul 31, 2008 3:39 am

session.Find() is for HQL queries, not direct SQL (as your query looks like). And session.Find() is deprecated (nhib 1.2 and later).

Code:

session.CreateQuery("FROM Class c WHERE c.Property1 is not NULL ORDER BY c.Property2").List();

should definitely work.