Hi,

I have one question, based on what I have read, because I don't undestand very well how to do that.

If I have a two tables, and in sql I would make a join with those tables, but, using nhibernate.
Should I make an string containg that join or there's another way to do that?, I don't know, using Criteria or other method.


'Cause, what I did until now, I load an object that has a list of other objects, that then I bind that with a DataGrid. But doing that, I can't see all the cells at one, undestand what I mean?
I have to click on every register, to the see the columns of the other table.

But, what if I want to show all the columns at once? Like if I were doing a join in sql?

Undestarnd what I mean?


Thanks a lot !!!

What I would suggest is you download the hibernate reference document from hibernate.org.

Look for <set> or <bag> or <list> mapping.
Normally you'll find the mapping definition to a collection. Just add the attribute setting fetch="join". This will make any of your calls to query() or load() method of Session object retrieve all the related collection records based on your table POJO mappings.

Kind regards,
roy
Please dont forget to give credit if I answered your inquiry.

I'll try that.

Thanks.