This question is locked. New answers and comments are not allowed.
I am having some trouble with my associations. I want a user model and a person model to have a one to one relationship. So I click the association tool, click the person model, then click the user model. For the source class I use the UserID, and for the target class I put the PersonID. Thats all fine. Now my trouble is what to do with the Identity Mechanism, on my first run I left both of them on default. Well default works fine until I try to add a second item to the database and I get an error sayings I cant use the same primaryId twice. So I try changing both of them to DatabaseServerCalculation then I get an error telling me that wont work cause the foreign key for person is being generated by the UserID. So now I try to just leave the UserId as DatabaseServerCalculated and the PersonId as default and I get this error.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "ref_User_Personal_Info_Bank_User". The conflict occurred in database "MyBank2", table "dbo.Bank_User", column 'UserId'.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "ref_User_Personal_Info_Bank_User". The conflict occurred in database "MyBank2", table "dbo.Bank_User", column 'UserId'.