Hi all,
This is my first experience with Hibernate and I'm reading my first tutorials. My Problem is simple:

"Products" has a "many-to-one" relationship with "Categories" but when I list "Products", I'm getting a "categoryID". How can I replace the "categoryID" by the "categoryName"? I need to display it in a DataGrid.

My Listing code (works perfectly but does not show category name)
ICriteria _criteria = Session.CreateCriteria(typeof(Products),"Products");
ProductsCollection _list = new ProductsCollection(this);
pCriteria.List(_list);

Are you sure the relationship maps to the product object, and not just the product id?

can you show the hibernate mappings which you are using. I suspect that you are failling into the most common OO trap and trying to set up relationships using IDs rather than thinking in terms of objects

Thanks
anand raman