Ok, before I start, I feel the need to admit that I'm not proud of what I'm trying to achieve, but basically, I'm stuck with a very bad legacy database and I'm trying to make the best of it for the developers.
I would like to solve the following: I have a Customer entity, which is mapped. [source: Customer table; basic customer fields] The customer, has an Address component. [source: Customer table; address related fields] I would like to include the country in the Address. Here is the catch; the country is not a column on the Customer table, it is a system wide setting. It would be located in a settings table. For Example: Table: CountrySetting Id: 1 CountryName: US When I load my Address component as part of my customer, I would like to include the "CountryName" as part of the Address. Mapped to a Property named "Country" on the Address object. For me, it is acceptable to assume that I know the Id of the CountrySetting row. I'm Using NH3 with Fluent NH. I know this sounds a bit crazy, but I don't want to have to go and read the settings table every time I want to print an address. Any help or alternate solutions are welcome. Best Regards -- 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.
