Defining Foreign Key Relationships in EF / MVC6

Question

I have extend the ApplicationUser class in the template models to include an optional Company:

public class ApplicationUser : IdentityUser
{
    public virtual Guid? CompanyID { get; set; }

    public virtual Company Company { get; set; }
}

And in the 'Company' class I've included a collection of ApplicationUsers:

    [Required]
    [Key]
    public Guid? CompanyId { get; set; }

    public virtual ICollection<ApplicationUser> Users { get; set; }

Do I also need to specify the relation in the ModelBuilder for the ApplicationdbContext? or should Code-First handle this for me?

I ask because when I grab _context.Users.ToList() in a controller Company is always null, even if CompanyID is populated for the ApplicationUser.

https://msdn.microsoft.com/en-us/library/gg671236%28v=vs.103%29.aspx#Anchor_1 — Steve Greene, Feb 28 '16 at 22:34

score 1 · Answer 1 · answered Feb 28 '16 at 20:19

1

Change Model To It:

[Required]
[Key]
public Guid CompanyId { get; set; }
public virtual ICollection<ApplicationUser> Users { get; set; }

And Config MolderBinder For ApplicationUser To this:

modelBuilder.Entity<ApplicationUser>().HasOptional(row => row.Company ).WithMany().HasForeignKey(row => row.CompanyID ).WillCascadeOnDelete(false);

answered Feb 28 '16 at 20:19

Reza Bahari

104
7

No `HasOptional` available - what's the namespace? – jidl Feb 28 '16 at 20:25
System.Data.Entity.ModelConfiguration – Reza Bahari Feb 28 '16 at 20:28
Not yet! That namespace doesn't seem to be available - is it ready for DNX 5? – jidl Feb 28 '16 at 20:46
Yes , The following references are available? EntityFramework , System.ComponentModel.DataAnnotations , System.Core , System.Data – Reza Bahari Feb 28 '16 at 20:51
See http://stackoverflow.com/q/35562483/2591770 - I think `HasOptional` has been removed from EF7 / Core – jidl Feb 28 '16 at 23:41

Defining Foreign Key Relationships in EF / MVC6

1 Answers1