Hi,

I have a table user with 4 rows:

- id
- firstname
- name
- age

I mapped user in class User. Now I want to make a query, where I get only the firstname and lastname of the table user.

Herr the sql query:

SELECT firstname, name
FROM dbo.user

my NHibernate query:

return session.CreateSQLQuery("select u.firstname, u.name from User u", "u", typeof(User)).List();

... ends with an error. But if I make the same query with all properties, it works ...

return session.CreateSQLQuery("select u.id, u.firstname, u.name. u.age from User u", "u", typeof(User)).List();

Why it doesn't run with only some properties?

regards,
Tribjun

I don't usually work with CreateSQLQuery, but here's my two cents worth;

the 2 strings from the FROM clause may not be able to be projected onto a new instance of type User. You should look into having the call return an array of strings instead of a instance of User.

ohw yeah, before I forget, it would be nice to be able to read the exception details with these kinds of problems...

Hi,

You can make a DTO class with the 2 properties you need, and then use Transformations for convert the resultset to the "DTO class".

Here are simples examples:
http://unhaddins.googlecode.com/svn/bra ... Fixture.cs

You can checkout here to get the completes examples with the libraries:
http://unhaddins.googlecode.com/svn/bra ... es.Course/