Hi,

How to get th following sql query in Nhibernate.

select e.firstname || e.middlename|| e.lastname , e.employeecode,e from employees e

When i try to do the same using IQuery in Nhibernate it gives me error

Thanks

Arvind

What error do you get ? Have in mind, that if you do that query with HQL you need property names instead of column names and that the resultset will be a 3-dim array with { "concatenated name", employeecode, instance of e }.

But instead of doing this in HQL I suggest a property on Employee that will do the concatenation.