I have a mapping that I use inside a Person class mapping:
Code:
<set
name="Participants"
cascade="save-update"
inverse="true">
<key
column="PersonId" />
<one-to-many
class="ISIS.Data.Core.Participant, ISIS.Data" />
</set>
The participants table is an older table and hasn't been migrated to our new structure (for instance, in the new structure, the PersonID would be a Guid, but for the Participants tabe, it is an Int). All the other code uses the Guid PersonId, so that is what I have the Id for Person mapped to. I need to join the Person and Participants table, so I tried using the
Code:
foerign-key
and setting it to IntId (the old IntId in the Person class), but the join still comes up as
Code:
INNER JOIN PARTICIPANT PARTICIPAN1_
ON THIS_.ID = PARTICIPAN1_.PERSONID
THIS_.ID being the primary key of Person (the Guid), that I want to be the IntId. Can I do this? Or do I need to add these Guid's to the Participant table?
If you need any other info, I will do my best to supply it.