Mapping properties from a foreign table twice in Fluent NHibernate

Question

I have 2 tables like this: (Please note the non-standard db schema naming)

table T_Pen
  TP_ID
  TP_PrimaryColorID
  TP_SecondaryColorID
  ...

table E_Color
  EC_ID
  EC_ColorName
  ...

And I want to create a mapping of the 2 tables to a domain object Pen using Fluent NHibernate.

class Pen
{
    PenID;
    PrimaryColorName;
    SecondaryColorName;
    ...
}

How can I do that?

Answer 1

class Pen {
int PenID;
Color PrimaryColor;
Color SecondaryColor;
}

class Color
{
int ColorID;
string ColorName;

}

class ColorMap
{
Id(x => x.ColorID);
Map(x => x.ColorName);
}

class PenMap
{
Id(x => x.PenID);
References(x => x.PrimaryColor).Column("TP_PrimaryColorID");
References(x => x.SecondaryColor).Column("TP_SecondaryColorID");
}

Answer 2

I don't think you would be able to Insert/Update anymore if you were to only reference the Name.

You could create a view of PenColour or hide the actual reference in your pen class and only expose the Name property.