How to map one-to-many relationship on following entites using Fluent API.
[Table("LU_COMMODITY_ID")]
public class LU_COMMODITY_ID
{
[Key]
public string COMMODITY_ID { get; set; }
public virtual string COMMODITY_DESC { get; set; }
...
public virtual ICollection<LU_SUPPLIER_COMMODITY> LU_SUPPLIER_COMMODITIES { get; set; }
}
[Table("LU_SUPPLIER_COMMODITY")]
public class LU_SUPPLIER_COMMODITY
{
[Key, Column(Order = 0)]
public string COMMODITY_ID { get; set; }
[Key, Column(Order = 1)]
public virtual string SUPPLIER_NAME { get; set; }
...
public virtual LU_COMMODITY_ID LU_COMMODITY_ID {get; set; }
}
I've tried the following mapping:
modelBuilder.Entity<LU_SUPPLIER_COMMODITY>()
.HasRequired(l => l.LU_COMMODITY_ID)
.WithMany(a => a.LU_SUPPLIER_COMMODITIES)
.HasForeignKey(l => l.COMMODITY_ID);
and it gave me next error:
The 'LU_SUPPLIER_COMMODITIES' property does not exist or is not mapped for the type 'LU_COMMODITY_ID'.