Setting up foreign key in ASP.NET MVC 4

Question

I have 2 models and want to create a foreign key relationship. Basically each note should be assigned to a user.

[Table("UserProfile")]
public class UserProfile
{
    [Key]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int UserId { get; set; }
    public string UserName { get; set; }
    public string Email { get; set; }
}

[Table("UserNotes")]
public class UserNotes
{
    [Key]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int NoteId { get; set; }

    [ForeignKey("UserProfile")]
    public virtual int UserId { get; set; }

    public string Title { get; set; }
    public string Content { get; set; }
    public string Added { get; set; }
    public DateTime? Edited { get; set; }  
}

When I attempt to add new user note I get: The ForeignKeyAttribute on property 'UserId' on type 'note.DO.Models.UserNotes' is not valid. The navigation property 'UserProfile' was not found on the dependent type 'note.DO.Models.UserNotes'. The Name value should be a valid navigation property name.

I have tried a lot of combinations including those found in similar questions but none of them worked.

Does this have anything to do with asp.net?

Jason Goemaat
– Jason Goemaat

2014-12-17 07:06:49 +00:00
Commented Dec 17, 2014 at 7:06 — Jason Goemaat
– Jason Goemaat, Commented Dec 17, 2014 at 7:06

Réda Mattar · Accepted Answer · 2013-10-22 12:12:55Z

17

Try this :

public virtual int UserId { get; set; }

[ForeignKey("UserId")]
public virtual UserProfile User { get; set; }

This way, you pair foreign key property with navigation property.

Edit : you can also write it like this :

[ForeignKey("UserProfile")]
public virtual int UserId { get; set; }

public virtual UserProfile UserProfile { get; set; }

Those two snippets gives the same result. Your error message says that "UserProfile" property is missing, you just have to add it.

answered Oct 22, 2013 at 12:12

Réda Mattar

4,3911 gold badge20 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ObedMarsh Over a year ago

Why do we need to use the virtual keyword when declaring foreign keys? Any chance you could answer that?

Collectives™ on Stack Overflow

Setting up foreign key in ASP.NET MVC 4

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related