select o.id, o.DefaultCulture.id, o.DefaultCulture.LCID from Organization o
2009/9/4 Lefty <[email protected]> > > Getting started with NHibernate, and this has stumped me. Consider > these tables. > > Organization > ========== > OrganizationId (PK) > Name > DefaultCultureId (FK) > > Cultures > =========== > CultureId (PK) > Name > LCID > > When I map the Organization entity, I would like to have these > properties: > > OrganizationId > Name > DefaultCultureId > LCID <== loaded from Cultures using the DefaultCultureId FK > > where LCID is retrieved from Cultures, using the DefaultCultureId (FK) > mapped to CultureId > > I think I could create a Culture entity and have a Culture property, > but I am trying to create a simple OrganizationDTO class with only the > properties that the UI needs. > > The closest I've come to getting this to work is with a <join> but > that loads the incorrect culture (uses OrganizationId for lookup > instead of the DefaultCultureId FK) > > To me this is the simplest of joins, but NH seems to be making it > difficult. > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
