我有兩個POCO課程public class Order{ int id; string code; int? quotationId; //it is foreign key public int Id{get;set;} public string Code{get;set;} public int? QuotationId{get;set;} Quotation quotation; public virtual Quotation Quotation { get; set; } ....}public class Quotation{ int Id; string Code; public int Id{get;set;} public string Code{get;set;} Order order; public virtual Order Order { get; set; } .... }每個訂單可能由一個或零個報價組成，并且每個報價都可能導致一個訂單，所以我有一個“一或零”到“一或零”的關(guān)系，我該如何首先通過fluent API在EF代碼中實現(xiàn)呢？
3 回答
長風秋雁
TA貢獻1757條經(jīng)驗 獲得超7個贊
通過將pocos更改為：
public class Order
{
public int OrderId { get; set; }
public virtual Quotation Quotation { get; set; }
}
public class Quotation
{
public int QuotationId { get; set; }
public virtual Order Order { get; set; }
}
并使用以下映射文件：
public class OrderMap : EntityTypeConfiguration<Order>
{
public OrderMap()
{
this.HasOptional(x => x.Quotation)
.WithOptionalPrincipal()
.Map(x => x.MapKey("OrderId"));
}
}
public class QuotationMap : EntityTypeConfiguration<Quotation>
{
public QuotationMap()
{
this.HasOptional(x => x.Order)
.WithOptionalPrincipal()
.Map(x => x.MapKey("QuotationId"));
}
}
我們將擁有該數(shù)據(jù)庫（即0..1-0..1）
HUWWW
TA貢獻1874條經(jīng)驗 獲得超12個贊
@Masoud的程序為：
modelBuilder.Entity<Order>()
.HasOptional(o => o.Quotation)
.WithOptionalPrincipal()
.Map(o => o.MapKey("OrderId"));
modelBuilder.Entity<Quotation>()
.HasOptional(o => o.Order)
.WithOptionalPrincipal()
.Map(o => o.MapKey("QuotationId"));
通過將代碼更改為：
modelBuilder.Entity<Order>()
.HasOptional(o => o.Quotation)
.WithOptionalPrincipal(o=> o.Order);
- 3 回答
- 0 關(guān)注
- 483 瀏覽
添加回答
舉報
0/150
提交
取消