I am having trouble finding documentation on how to use HQL to lookup values from a composite foregn key.

looking at the mapping document below i have a person class which has a composite id. i want to look up a list of EFTInfo's that are linked to that person.

I can load the person object fine as i have the ID's

How can i lookup the EFTInfos from that point or where would i find this documentation.

should i have some dort of reverse mapping in my person hbm.xml?

Mapping documents:

ok i thought i had found it. The problem is i was hopping to just assign the composite type ID in the HQL (ie. person.ID = ?) but i belive i need to specify right down to the lowest level of the composite foreign Key.

person.Id.ID =? and person.Id.DataBaseID = ?

but i still get an error:

could not resolve property:Id of person [from EftInfo as ei where ei.person.Id.Id = ? and ei.person.Id.DataBaseID = ?]

any ideas?

I'm fairly new to NHibernate, but I've tried the composite key thing. Why don't you redefine your hbm like so:

<class name="EftInfo" table="eft_info">
<composite-id name="Id" class="ID">
<key-property name="Id" column="eft_info_id" type="int" />
<key-property name="DataBaseID" column="eft_info_db_id" type="int" />
</composite-id>


<property name="Description" column="descr" type="AnsiString" length="60" not-null="true"><!-- [descr] [varchar] (60) --></property>

</class>

with the class:

class EftInfo
{
private int _Id;
private int _dbId;

public int Id
{ get { return _Id; } set { _Id=value; }}

public int DatabaseID
{ get { return _dbId; } set { _dbId=value; }}
}

Then you do:

EftInfo eInfo = new EftInfo()
eInfo.Id = 10;
eInfo.DatabaseID=100;

Avoid the sub-object.