This question is locked. New answers and comments are not allowed.
How do I go about modeling a 1:1 association in OpenAccess? In my Entity Framework model, we have some entities that are related to each other in that the primary key is the same for each table (they are basically extensions of the same table). This is modelled as a 1:1 association in the Entity Framework, but when the association was converted over to OpenAccess, it comes over as a 0:Many association so on one end of the association I have a list, rather than a reference.
For instance I might have a Customer entity, and then another CustomerInfo entity that are stored in separate tables because the stuff in CustomerInfo is not used very often (or may not be present for some customers) so it saves space in the database. They both have CustomerID as the primary key, and I need to set this up as 1:1 association? Or a 1:(0 or 1) association in some instances.
When I open the association in the designer, and try to edit it, the type of the association end point is grayed out and I am not able to change it from 0 to many, to 0 to 1 or 1 depending on the entity I am editing. Is there something I have to do differently to model this in the designer? Or do I need to delete the association and re-create it again (does it support 1:1 in that case)?
For instance I might have a Customer entity, and then another CustomerInfo entity that are stored in separate tables because the stuff in CustomerInfo is not used very often (or may not be present for some customers) so it saves space in the database. They both have CustomerID as the primary key, and I need to set this up as 1:1 association? Or a 1:(0 or 1) association in some instances.
When I open the association in the designer, and try to edit it, the type of the association end point is grayed out and I am not able to change it from 0 to many, to 0 to 1 or 1 depending on the entity I am editing. Is there something I have to do differently to model this in the designer? Or do I need to delete the association and re-create it again (does it support 1:1 in that case)?