I was reading through the manual/online docs but am unsure how to map this scenario, and hoped someone could help.

I have an Order class, and this order has two addresses (address class). One is a billing address and the other is delivery address. The address table has a discriminator column differentiating between the two.




The address table has two relevant columns, the OrderID - which order the addresses relate to, and the Type (discriminator) - billing or delivery addresses. Each other has one or two addresses (Delivery Address is optional). There should never be two billing addresses for an order, they are 1 to 1 mappings.

Can anyone help me out with the suitable mapping please?

Hello, you could use a mapping like this,



regards,

Thanks for the reply. I should clarify there is only every one address per billing and delivery.

The addresses are both stored in the same table, "addresses" and there is the "Type" column to distinguish which is which. (billing/delivery)

Bags are for collections? Though I may have confused things with the number of addresses before. Each has one. So the definition of an IOrder has two properties of IAddress containing either null, or an class implementing IAddress.

With your sample for billing address component, I am not sure how that links to the address table (and gets the correct address based on OrderID and Type. Please could you clarify.

Many thanks

Simon

What i'm trying to do with this mapping it's that the Billing Address 1:1 it's stored directly in the Orders Table and the Shipping address because it's an 1:n be stored in it's own table ShippingAddresses.

The <bag> represents an unindexed collection. I kinda prefer this kinds on collections instead of the <list> because for the list needs an extra column in the table to store the index of the list,


I hope this clarify the things a little bit,

regards,

Thanks,

Trouble is the database is already defined :-)

There is 1:1 on both billing and delivery addresses so the interface IOrder works (it has two IAddress objects)

I guess what I want is a 1-2-1 mapping, but I'm not sure how to use the discriminator to differentiate the address types.

Cheers

Simon