請教下EF問題,高手進來幫看下
public class SJResourceReqMAS
{
[Key]
public int rr_Id { get; set; }
[Display(Name = "申請人")]
public string rr_requsr { get; set; }
[Display(Name = "電話")]
public string rr_reqext { get; set; }
[Display(Name = "申請日期")]
public System.DateTime? rr_date { get; set; }
[Display(Name = "部門")]
public string rr_dept { get; set; }
[Display(Name = "申請內容")]
public string rr_typ { get; set; }
[Display(Name = "需求日期")]
public System.DateTime? rr_reqdate { get; set; }
[Display(Name = "申請原因")]
public string rr_reason { get; set; }
public string rr_approvedby { get; set; }
public Nullable<System.DateTime> rr_approveddte { get; set; }
public string rr_sts { get; set; }
public string lusr { get; set; }
public System.DateTime? ldte { get; set; }
[Display(Name = "備註")]
public string rr_remark { get; set; }
public virtual SJResourceReqDtl SJResourceReqDtl { get; set; }
// public virtual List<SJResourceReqDtl> SJResourceReqDtl { get; set; }
}
public partial class SJResourceCatMAS
{
[Key]
public int rc_Id { get; set; }
public string rc_cat { get; set; }
public string rc_code { get; set; }
public string rc_desc { get; set; }
public string rc_uom { get; set; }
public string rc_sts { get; set; }
public string lusr { get; set; }
public System.DateTime? ldte { get; set; }
}
[Table("SJResourceReqDtl")]
public partial class SJResourceReqDtl
{
[ForeignKey("SJResourceReqMAS")]
[Key, Column("rd_Id", Order = 1)]
public int rd_Id { get; set; }
[ForeignKey("SJResourceCatMAS")]
[Key, Column("rc_Id", Order = 2)]
public int rc_Id { get; set; }
public Nullable<short> rd_qty { get; set; }
public string rd_desc { get; set; }
public virtual List<SJResourceReqMAS> SJResourceReqMAS { get; set; }
public virtual SJResourceCatMAS SJResourceCatMAS { get; set; }
}
報錯:The foreign key component 'rd_Id' is not a declared property on type 'SJResourceReqMAS'. Verify that it has not been explicitly excluded from the model and that it is a valid primitive property.
外国关键组件的rd id”不是一个声明的属性类型的SJResourceReqMAS’。确认它没有被明确地排除在模型,它是一个有效的原始属性。
當我把[ForeignKey("SJResourceReqMAS")]註釋掉就映射成功了,但是也改變了SJResourceReqMAS結構如圖:
--------------------编程问答-------------------- 沒人嗎?沒人嗎?
补充:.NET技术 , C#