Hi silveraxe, thanks for the reply.
Quote:
first thing: Product_Id is redundant in the Order_Detail table. Product_Color_Id seems to be the PK and therefore you just need a reference to that key. From there you can go to the Product and Color.
Yes, I know. Unfortunately I inherited this database and can't change the structure.
Quote:
The class A has a generic list of type B and the mapping for A has the following entry:
In my case, I have table A, B, and A_B where A is a one-to-one with A_B, and A_B is a one-to-one with with B. So with my POCO I need to have A.B and NOT A.IList<B>, because there is always only one B. I have some many-to-many references, but this is actually a one-to-one reference that goes through another table, which I haven't seen any examples for.