When I try to assign an alias to a column in named query, I get a compilation query error.

Example:

<query name="PersonTest1">
<![CDATA[

SELECT
p.FirstName as Name,
p.LastName as Name2
FROM Person p

]]>
</query>

I want to execute this query an transform to an DTO (with Transformers.AliasToBean) but I get error for the alias.

HQL is not the same as SQL, although they look very similar. Just use "from Person" and get a list of Person objects back and you have all the properties on the Persons; that's the power of NHibernate. If you just want the first name and last name, drop the column aliases and you will get a list of Object arrays. "result[0][0]" and "result[0][1]" gives you the first name and last name from the first row respectively.

Ok,

But, how can I do to bind this result to a GridView?

You can bind the IList<Person> to a GridView just like how you would with a DataSet or DataTable.

Yes,

But, I dont want bind the IList<Person>. I just want bind IList with Name and LastName.

This has just become an ASP.NET question... you don't have to show all the properties in the GridView. You can set up the GridView to have only two columns to show the Name and LastName property. If you don't know how to do that, I suggest you post the question in an ASP.NET forum.

I know how to do that,

But If I do IList<Person> NHibernate load all collumns from the table, and if I do "select Name, LastName from Person" NHibernate load only this columns.

This HQL will load only the Name and LastName into an array of object[] (i.e. object[][]):

This HQL will load the properties into a LightPerson class:
... provided LightPerson has a matching constructor.
See here:
http://www.hibernate.org/hib_docs/nhibe ... hql-select

ok,

Thanks