Conflicted foreign key sql

Asked Feb 25 '13 at 08:21

Active Feb 25 '13 at 08:21

Viewed 242 times

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_dbo.UserProfile_dbo.UserWork_UserWorkId". The conflict occurred in database "aspnet-UserAndWork-20130222085848", table "dbo.UserWork", column 'UserWorkId'. The statement has been terminated.

I run into the error message while loading the page Here are two of my tables classes

public class UserProfile
{
    [Key]
    public int UserId{get;set;}
    public string Username{get;set;}
    public int UserWorkId{get;set;}
    [foreignkey("UserWorkId")]
    public virtual UserWork UserWorkLog{get;set;}
}

public class UserWork
{
    [Key]
    public int UserWorkId{get;set;}
    public int UserId;
    //somemoire
}

asked Feb 25 '13 at 08:21

Asp Asp

1

Apparently you are trying to save `UserProfile` instance with nonexistent reference to the `UserWork`. How is you saving done in code? – Andrei Feb 25 '13 at 08:26
check here : http://stackoverflow.com/questions/2965837/insert-statement-conflicted-with-the-foreign-key-constraint – AliRıza Adıyahşi Feb 25 '13 at 08:27
shouldnt this line "[foreignkey("UserWorkId")]" above "public int UserWorkId{get;set;}" ? – DevelopmentIsMyPassion Feb 25 '13 at 09:08

Conflicted foreign key sql

0 Answers0