EF 4.1 Code The first foreign key adds an extra column

Question

I have the following two entities (among many, but this gives me a problem)

public class StartPoint
{
    public int StartPointId { get; set; }
    public string Description { get; set; }
    public int StartPointNumber { get; set; }    
    public int StartAreaId { get; set; }
    public StartArea StartArea { get; set; }
}    

and

public class StartArea
{
    public int StartAreaId { get; set; }
    public string Description { get; set; }
    public ICollection<StartPoint> StartPoints { get; set; }
}

When EF creates my database, he complained that I needed to disable cascading deletion due to several paths, which I did as follows.

        modelBuilder.Entity<StartPoint>()
            .HasRequired(x => x.StartArea)
            .WithMany()
            .HasForeignKey(x => x.StartAreaId)
            .WillCascadeOnDelete(false);

, , StartAreaId, , - StartArea_StartAreaId. StartAreaId. StartArea_StartAreaId. HasForeignKey StartAreaId , StartArea_StartAreaId, StartArea_StartAreaId StartArea_StartAreaId1. , ? , StartAreaId .

Answer 1

WithMany:

    modelBuilder.Entity<StartPoint>()
        .HasRequired(x => x.StartArea)
        .WithMany(y => y.StartPoints)
        .HasForeignKey(x => x.StartAreaId)
        .WillCascadeOnDelete(false);