Hey guys!

Following problem is giving me a hard time and I seem to be unable to find anything helpful on the web.

Example:
I've got a table COMPANY and a table ROLE.
Companies shall have roles assigned to them (n:m), so that company 'Hew Pack' might be 'Printer Manufacturer' and 'Software Manufacturer'. So I've got a table LINK_COMPANY_ROLE as well, which does just that. Furthermore my .hbm.xml file for COMPANY contains a bag 'roles'.

I now want to be able to do a query, which returns all those companies, who are assigned the 'Software Manufacturer' role (so who's bag contains that role).
Yet I'm absolutely clueless how to do that.

I'd be very grateful, if you could point me into the right direction and/or provide me with a sample which does something similar.

Have a nice day
Benjamin

Morning!

I've just solved my above problem, which was pretty easy, as already expected.
Just needed to find how to do it :)

For all those interested, I recommend reading following blog by Ayende:
http://ayende.com/Blog/archive/2006/10/ ... rnate.aspx

Have a nice day