Hello,

I havent touched NHibernate in a few months so im a bit out of touch with it, however ive got a semi complicated relationship between my objecs and tables and im not quite sure how to map them... Its old code that used to use Microsoft EnterpriseLibrary and im trying to convert it over to use NHibernate...

To simplify the problem here is an example of what table structure i have:



Now I have 2 main classes, which both use a 3rd class as a reference to the TypeTable but use it as an enum in the classes... rather than explain here is an example:



Now im not sure how to represent this TypeWithValue with a mapping file, as the 2 classes would have their own mapping files, however they would both need to reference the TypeWithValue class somehow to populate its properties.

The main thing im having difficulty getting my head around is how im going to be able to get the Id for the Enums value from the same table every time, but get the value from a different one depending on the parent class.

If it helps the old SQL was something like this:



Unfortunately this TypeWithValue<T1,T2> is used in lots of different places to represent an enum with a coresponding value... an example would be something like someones score for a school subject, so you would have the enum value being "LessonType.Geography" and the value being 100 being top score...

I was thinking that its more of a component but its data comes from multiple tables, but i cant make 1 mapping for the TypeWithValue as its Value comes from different places, and i wasnt sure if i could make a mapping for it but exclude Value and pump it in from elsewhere...

Any help would be great, ive tried to be as descriptive with my problem as possible...

Just realised i was being a nugget... A trip to the loo reminded me that i already have the TypeId within the Table1, Table2 so i can use it as a component after all!