I have two tables, each mapped to a C# class.

Table Person
========
PK - PersonID

Table Supporter
==========
PK - SupporterID
FK - PersonID

I'm trying to set up the mapping of the Person class in the HBM - but I get no success.

I've tried using -

<one-to-one name="Supporter" constrained="true" class="Supporter"/>

I get no data returned i.e the Supporter property of the Person instance is null.

If I run the corresponding SQL -

select supporter.* from person
inner join supporter on person.personid = supporter.personid
where person.personid='46'

then I get a row returned.

What am I doing wrong?

Cheers.

TeaVR

I think you don't have a one-to-one relationship.

one-to-one is only a choice between two tables who have the same primary key.
From Supporter you have a many-to-one mapping. Because a Person could be in multiple supporter rows.