I'm running the following query to try and load the rows for my database (SQL Server, 2005 i think),

System.Collections.IList people;

(other code)

string HQL = "from person as p order by p.Name asc";
people = session.Find (HQL);

I'm getting the following error:
NHibernate.QueryException: unexpected token : as [from person as p order by p.Name asc]

I'm using visual studio express edition 2005, like i said i'm pretty sure its sql server 2005.

mapping file:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns ="urn:nhibernate-mapping-2.0">
<class name ="ListQuery.Persons, ListQuery" table="person">
<id name="Id" column="ID">
<generator class ="increment"/>
</id>
<property name="Name" column ="Name"/>
<property name="Birthday" column="BirthDate"/>
</class>
</hibernate-mapping>

something must have been wrong with a mapping file, cause I copied the statements into another NHibernate program that worked and then the statements worked, so I don't know other than a mapping file.

try

nHibernate is case sensitive so Person and person are not the same (it's the class name you use not the table name)

actually according to the documenation HQL is case insensitive.



the pdf can be found at
http://www.hibernate.org/hib_docs/nhibe ... erence.pdf

person was the name of my table and Name was a property but you were right in that person is not the same as Person nor is name equal to Name so long as its a property and like i said, i copied the hql statement into another working nhibernate soluntion and it worked but thanks for the response.

As you posted, the queries are case insensitive "except for names of .NET classes and properties." In the HQL query below, "Persons" is a .NET class name, not a table name. The same as Name is a property on the Person class, not a column in the table.

ok, I thank you for the posts, but the problem as been solved so no futher posts are needed.