I'd rearchitect if possible to have Address have no references, and then have join tables between.
People Id Businesses Id Addresses Id PeopleAddresses PersonId AddressId BusinessesAddresses BusinessId AddressId On Fri, Jun 5, 2009 at 3:08 PM, Plácido Bisneto <[email protected]>wrote: > From the database perspective, I am almost 100% sure that you cant do it: > *OwnerId (FK to either People or Business table)* > > Try not to declare the relationship to People and Business tables. > > It's not the best, but will work. :) > > Plácido Bisneto > > > 2009/6/5 Peter <[email protected]> > > >> Lets assume people and businesses can have multiple addresses. The >> table schema would look like this: >> >> People: >> Id >> >> Businesses: >> Id >> >> Addresses: >> Id >> OwnerType (can be person or business) >> OwnerId (FK to either People or Business table) >> AddressType (Enumeration) >> ActualAddressData >> >> The person object and business object both have a IList<Address> >> collection. How do I create a collection in the People and Business >> mappings such that the right Addresses are loaded? >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
