>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
-~----------~----~----~----~------~----~------~--~---

Reply via email to