How to resolve: error while attempting to add FK

[extrakun]

I keep getting this error while attempting to add a FK in table.

Code: Select all

Properties referred by the Principal Role ASPNET_USERS
 must be exactly identical to the key of the EntityType MyApp.Models.Store.ASPNET_USERS
 referred to by the Principal Role in the relationship constraint for Relationship MyApp.Models.Store.FK_UserInfo_AspnetUsers. 
Make sure all the key properties are specified in the Principal Role.

What exactly does this means?

The table schema is

Code: Select all

ASPNETUSERS 

Column                 Type
-------                --------
UserID (PK)                 GUID
...
UserInfoID             NUMBER


USERINFO

Column                 Type
-------                --------
ID (PK)                      NUMBER

I am attempting to add a 1 to 1 relationship from ASPNETUSERS to USERINFO, using UserInfoID to ID. UserInfoID from ASPNETUSERS is not a key.

[AndreyR]

Entity Framework treats the one-to-one relationship as a relationship between two Entity Keys.
You can create a view that performs a join of User and UserInfo tables, and add this view as an entity to your model.
As an alternative you can go into Entity Splitting.