在我看来这应该有效:
public class Photo
{
[Key, ForeignKey("Parent"), Column(Order = 1)]
public int PhotoCollectionId { get; set; }
[Key, Column(Order = 2)]
public int PhotoId { get; set; }
public virtual PhotoCollection Parent { get; set; }
public virtual ISet<PhotoProperty> PhotoProperties { get; private set; }
//...
}
public class PhotoProperty
{
[Key, ForeignKey("Parent"), Column(Order = 1)]
public int PhotoCollectionId { get; set; }
[Key, ForeignKey("Parent"), Column(Order = 2)]
public int PhotoId { get; set; }
[Key, Column(Order = 3)]
public int PhotoPropertyId { get; set; }
public virtual Photo Parent { get; set; }
//...
}
注意PhotoCollectionId
in PhotoProperty
不指的是PhotoCollection
但是复合外键的一部分(PhotoCollectionId,PhotoId)
指的是Photo
.
是的,您可以使用 Fluent API 定义整个映射:
modelBuilder.Entity<PhotoCollection>()
.HasMany(pc => pc.Photos)
.WithRequired(p => p.Parent)
.HasForeignKey(p => p.PhotoCollectionId);
modelBuilder.Entity<Photo>()
.HasKey(p => new { p.PhotoCollectionId, p.PhotoId });
modelBuilder.Entity<Photo>()
.Property(p => p.PhotoId)
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
modelBuilder.Entity<Photo>()
.HasMany(p => p.PhotoProperties)
.WithRequired(pp => pp.Parent)
.HasForeignKey(pp => new { pp.PhotoCollectionId, pp.PhotoId });
modelBuilder.Entity<PhotoProperty>()
.HasKey(pp => new { pp.PhotoCollectionId, pp.PhotoId, pp.PhotoPropertyId });
modelBuilder.Entity<PhotoProperty>()
.Property(pp => pp.PhotoPropertyId)
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);