MVC3中EF关系的问题

Question

我得到以下代码：

public class Trip
{
    public int TripId { get; set; }

    public int DriverId { get; set; }

    public string StartingPoint { get; set; }

    public string Destination { get; set; }

    public DateTime TimeDepart { get; set; }

    public int SeatAvailable { get; set; }

    public virtual Carpooler Carpooler { get; set; }

    public virtual ICollection<Passenger> Passengers { get; set; }
}

public class Driver
{
    public int DriverId { get; set; }

    public int TripId { get; set; }

    public virtual Trip Trip { get; set; }
}

public class Passenger
{
    public int PassengerId { get; set; }

    public int TripId { get; set; }

    public virtual Trip Trip { get; set; }
}

模型构建器：

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {

        //one-to-one between Trip and Carpooler
        modelBuilder.Entity<Trip>()
            .HasRequired(x => x.Carpooler)
            .WithRequiredDependent();
        modelBuilder.Entity<Carpooler>()
            .HasRequired(x => x.Trip)
            .WithRequiredPrincipal();
        base.OnModelCreating(modelBuilder);

        //zero or one-to-many between Trip and Passenger
        modelBuilder.Entity<Trip>()
        .HasOptional(x => x.Passengers);

        modelBuilder.Conventions.Remove<IncludeMetadataConvention>();
    }

初始化器：

Database.SetInitializer<LiveGreenContext>(new CarpoolTripInitializer());

我收到以下错误： 关系“Trip_Driver”中的角色“Trip_Driver_Target”中的多重性无效。由于从属角色属性不是关键属性，因此从属角色的重数上限必须为*。

有什么解决办法吗？谢谢！

Answer 1

配置Trip和Driver之间的关系。 Trip 中有一个未配置的 DriverId 属性。如果您打算将其用作导航属性，您也需要对其进行配置。

OnModelCreating 方法中的某些配置不完整，现已更正。

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    modelBuilder.Entity<Driver>()
        .HasRequired(x => x.Trip)
        .WithMany()
        .HasForeignKey(x => x.TripId);

    //one-to-one between Trip and Carpooler
    modelBuilder.Entity<Trip>()
        .HasRequired(x => x.Carpooler)
        .WithRequiredDependent();

    modelBuilder.Entity<Carpooler>()
        .HasRequired(x => x.Trip)
        .WithRequiredPrincipal();

    //zero or one-to-many between Trip and Passenger
    modelBuilder.Entity<Trip>()
    .HasMany(x => x.Passengers)
    .WithRequired(x => x.Trip)
    .HasForeignKey(x => x.TripId);

    base.OnModelCreating(modelBuilder);

    modelBuilder.Conventions.Remove<IncludeMetadataConvention>();
}