Hey guys,

I recently started using NHibernate and in the meantime my application goes beyond retrieving either all objects of a type or objects by their ID, meaning I'm using HQL queries.

Lets look at this query: "from User where FirstName=? and LastName=?". I have a domain class "User", which is mapped to "ReportUser" in a database. Furthermore, the User class has a "FirstName" property of type string, which is mapped to the column "FirstName1" in the DB (note the 1 in the end).
So here the expression "User" is referring to the name of my domain class and FirstName is supposed to be referring to the name of my domain class' property.

However, the query fails saying:
NHibernate.ADOException : Could not execute query
----> System.Data.SqlClient.SqlException : Invalid column name 'FirstName'.

When I replace FirstName with FirstName1 everything works. So obviously here I have a dependency between my business logic and the database. Furthermore it seems to me inconsistent that with User I'm referring to a mapped domain class and with FirstName1 I have to refer to a DB object.

Either I'm doing something wrong (could someone tell me how to use FirstName instead of FirstName1) or this is a bug.

What do you guys think? BTW: I just updated to the newest NHibernate, 0.9.1.

Thanks, Christoph

Forgot to mention one thing. This is the SQL that was generated (extracted from SQL Profiler):
exec sp_executesql N'select user0_.ID as ID, user0_.FirstName1 as FirstName1, user0_.RoleID as RoleID, user0_.LastName as LastName, user0_.CoordinatorOpID as Coordina6_, user0_.DivisionID as DivisionID from ReportUser user0_ where (FirstName=@p0)and(LastName=@p1)', N'@p0 nvarchar(4000),@p1 nvarchar(4000)', @p0 = N'Admin', @p1 = N''

Try using an alias to reference your type:



Cheers,

Symon.

Note that entities/properties in HQL are ALWAYS refering to the Domain Model (== the classes and their properties).

Hey Symon, thanks for your hint. It worked beautifully :D

KPixel, sorry but from all I can tell you're wrong. If I use the ISession.Find method with these two queries I get two different results:

1) "from User where FirstName=?"
vs
2) "from User u where u.FirstName=?"

The first one generates a SQL statement using FirstName directly as column name, whereas the second one uses FirstName to lookup the column mapping and in my case produces a SQL statement with FirstName1 as column name.

This seems to me like a bug so I'll see that I can create a little test app that I can submit.

Regards, Christoph

I never used the 1) :oops:

Anyway, this is probably a design choice because it would be very hard (in 1) to map 'FirstName' as NHibernate will have to guess which class it belongs to (is not straightforward with complex HQL)...