Case When SQL Statement

Crolis · **Joined:** Tue Apr 01, 2008 4:16 pm **Posts:** 6

Hibernate version: 1.2

Name and version of the database you are using: SQL Server 2005

When trying to do any Session.CreateQuery("Select Case When...THEN...ELSE...END AS ReturnValue") type query I get this error:

NHibernate.QueryException : undefined alias or unknown mapping: case [select case when 1 then 1 else 0 end]

Any ideas?

wolli · **Posted:** Fri Jun 27, 2008 3:36 am

Afaik, this is not supported in HQL, try a SQL query instead:

session.CreateSQLQuery(...)

Have a look at http://www.hibernate.org/hib_docs/nhibernate/1.2/reference/en/html/querysql.html

pyhavaim · **Joined:** Sun Oct 22, 2006 12:06 pm **Posts:** 39

For this scenario you can use unmapped business object

Case Version when 10 then 1 else 0 end

Code:

Class Issue
{
    //this is mapped property in xml
    int virtual Version {get; set;}

//this is not mapped value
    bool virtual IsVersionTen
   {
        return Version==10;
   }

}