hi, i'm new to the forum. i'm doing now the "summer of nhibernate" tutorial (even though we're in the winter...)
anyway i found weird error using hql.

this query works perfect :

return session.CreateQuery("from Customer e where e.FirstName=:fn")
.SetString("fn",firstname).
List<Customer>();

but this one dose'nt work:

return session.CreateQuery("select from Customer e where e.FirstName=:fn")
.SetString("fn",firstname).
List<Customer>();

the only difference ,as you can see, is the word "select" in the beginning of the query.

what's the reason for that?

i'm using the newest version of nhibernate (2.1.2)

Hi,

Try "select e from Customer e where e.FirstName=:fn" as query string.

This should do the trick.

Explanation:
The "e" immediately after the select specifies that you want to retrieve all objects of type Customer that satisfy the where clause. If you completeley omit it, it would be as if you selected "SELECT FROM DBTABLE" in SQL. In such case, you would need to put a "*" after the SQL SELECT.
Alternatively, you could also select single properties using the HQL select query, e.g. (I assume you Customer class has got a property name): select e.Name from Customer where e.FirstName=:fn.

Hope this helps.

I also started a small tutorial series about nhibernate on my blog, and you are kindly invited to also have a look there.

Best regards,
Martin W. Angler
http://angler.wordpress.com (blog about c#, nhibernate, Pex, Code Contracts, etc.)

thanks!
did the job...