Foreign Key with Fluent Entity Framework

Question

I have created a News Model. My News have an author which is of the Member Class. is this enough for the foreing key to be set?

 HasRequired(n => n.Author);

Code:

public class Member : Identity
{
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Email { get; set; }
    public Address Address { get; set; }
    public int Id { get; set; }

    public virtual ICollection<News> News { get; set; }

}

public class News
{
    public string Title { get; set; }
    public string Subtile { get; set; }
    public int Id { get; set; }
    public string Url { get; set; }
    public DateTime DateAdded { get; set; }


    public virtual Member Author;

}
public class NewsMap : EntityTypeConfiguration<News>
{
    public NewsMap()
    {

        HasKey(n => n.Id);
        Property(n => n.Id).
            HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity)
            .HasColumnName("Id");

        Property(t => t.Title)
            .IsRequired()
            .HasMaxLength(100)
            .IsUnicode();
        Property(t => t.Subtile)
            .IsRequired()
            .HasMaxLength(100)
            .IsUnicode();
        Property(t => t.Url)
            .IsRequired()
            .HasMaxLength(255)
            .IsUnicode();
        Property(t => t.DateAdded).HasColumnName("DateAdded")
            .HasDatabaseGeneratedOption(DatabaseGeneratedOption.Computed);

        HasRequired(n => n.Author); //is this enough for the foreing key to be set?



    }

}
public class MemberMap : EntityTypeConfiguration<Member>
{
    public MemberMap()
    {
        // Primary Key
        this.HasKey(t => t.Id);

        // Properties
        this.Property(t => t.FirstName)
            .IsRequired()
            .HasMaxLength(150);

        this.Property(t => t.LastName)
            .IsRequired()
            .HasMaxLength(50);

        this.Property(t => t.Email)
            .IsRequired()
            .HasMaxLength(150);

        this.Property(t => t.Address.Id)
            .IsRequired()
            .HasMaxLength(100)
            .HasColumnName("Address_FirstLine");

        this.Property(t => t.Address.ZipCode)
            .IsRequired()
            .HasMaxLength(20).HasColumnName("Address_Zip");

        this.Property(t => t.Address.Contry)
            .IsRequired()
            .HasMaxLength(100).HasColumnName("Address_Contry");

        this.Property(t => t.Address.City)
            .IsRequired()
            .HasMaxLength(100).HasColumnName("Address_Town");

        this.Property(t => t.Id);


        // Table & Column Mappings
        this.ToTable("Identities_Member");
        this.Property(t => t.FirstName).HasColumnName("FirstName");
        this.Property(t => t.LastName).HasColumnName("LastName");
        this.Property(t => t.Email).HasColumnName("Email");
        this.Property(t => t.Id).HasColumnName("Id");

        // Relationships



    }
}

It is not enough. It is too much. Well, strictly speaking. The FK will even be set (as in generated in the database's data model) without the `HasRequired`. With it, the FK will be not nullable. — Gert Arnold, Sep 27 '12 at 15:01
Bonus question, saves me from creating another topic. I have Hierarchy by Type. In my database the Identity entry already exists, i now want to add a member(derived class of Identity). I tried to use context.members.AddorUpdate(new Member { id = }). I get a validation failed for one or more entities. — Poul K. Sørensen, Sep 27 '12 at 15:20
You should create another topic and show the complete configuration of Member and the internal exception message. — Andriy Svyryd, Oct 01 '12 at 16:55
I remodelled as i could not find a solution. Thanks for the assist. — Poul K. Sørensen, Oct 01 '12 at 19:53

score 0 · Accepted Answer · edited May 23 '17 at 12:12

0

Thanks @Gert for the answer:

It is not enough. It is too much. Well, strictly speaking. The FK will even be set (as in generated in the database's data model) without the HasRequired. With it, the FK will be not nullable.

edited May 23 '17 at 12:12

Community

1
1

answered Oct 01 '12 at 19:54

Poul K. Sørensen

16,950
21
126
283

Foreign Key with Fluent Entity Framework

1 Answers1