Hello.

Can I map only one colunm from anoter table?
For example, I have a table Order, every Order has Customer, I want include to Order only CustomerName, not whole Customer!
I know that I may write:

But I needn't Customer, I want map only Customer.Name. How do it?

Thanks.

You can't map fields from multiple tables into a single class, however you can access the information using an HQL query.

You can do this two ways:

1. You can provide a join in your HQL and include the additional field you want in your SELECT statement



In this case the you map the Customer's primary key as a foreign key in the Orders table. The result will be a list of 2 dimensioned arrays where the first dimension is the Order and the second dimension is a string containing the Customer's name.

2. You can use an new class to wrap the information together using the HQL NEW keyword. You can find information about it in the documentation, but in essence you do the same thing as in step one but you indicate to NHibernate that each result should be passed to the constructor of a new object which exposes all of the data you want to expose.

Hope that helps,

Symon.

Thanks a lot! I'll try to do this.