NHibernate Mapping from multiple tables

Question

Consider the following table structure...

Appointment
-----------
ID integer
Description nvarchar
StatusID smallint

Status
------
ID smallint
DisplayText nvarchar

Now, for good or for evil, we want this situation to map to a class that looks like this

class Appointment
{  
    public int ID {g;s;}
    public string Description { g;s; }
    public string Status { g; private s; }
}

I.e. we want to pull the normalised status display text straight into the entity.

chrismeek · Accepted Answer · 2008-12-04 12:19:52Z

4

The obvious answer is to create a Status entity and make the appointment class have a reference to that and map it in the normal way.

answered Dec 4, 2008 at 12:19

chrismeek

815 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

If you go this way you can use the component or one-to-one mappings

Tim Scott · Accepted Answer · 2008-12-05 02:59:40Z

2

Don't create an entity class. Use an enum and EnumStringType as shown here. This is exactly what you want I think.

answered Dec 5, 2008 at 2:59

Tim Scott

15.2k9 gold badges71 silver badges81 bronze badges