如何在Entity Framework中以一对零或一对一关系保存数据
如何在Entity Framework中以一对零或一对一关系保存数据
提问于 2018-07-09 08:09:09
我有两个表，它们的关系是一对零或一，即InvoiceSale和Budget。销售发票可以有一个Budget (也可以没有)，但每个Budget只属于一个销售发票。
这是我的InvoiceSale类：
public class InvoiceSale
{
public int Id { get; set; }
public int NumberInvoice { get; set; }
public DateTime InvoiceSaleDate { get; set; }
public Budget Budget{ get; set; }
}这是我的Budget类：
public class Budget
{
public int Id { get; set; }
public byte StateId { get; set; }
public long Total { get; set; }
public InvoiceSale InvoiceSale { get; set; }
}这是我对关系的流畅API配置：
HasOptional(fv => fv.Budget)
.WithOptionalDependent(p => p.InvoiceSale)
.Map(m => m.MapKey("BudgetId")); //I don't have a navigation property for
//this当我从表单发送数据时，我发送了一个下拉列表的NULL值，但是当我试图在实体框架中保存更改时，可选字段BudgetId总是插入BudgetId。
因为我没有BudgetId的导航属性，所以我不知道如何使用实体框架将这个值发送到数据库。
下面是插入数据的控制器操作：
[HttpPost]
public ActionResult CreateInvoiceSale(InvoiceSale newInvoiceSale)
{
var invoiceSale = new InvoiceSale
{
NumberInvoice = newInvoiceSale.NumberInvoice ,
InvoiceSaleDate = newInvoiceSale.InvoiceSaleDate ,
// Here I need to pass the BudgetId value, but how can I do it
// without a navigation property?
};
_context.InvoiceSales.Add(invoiceSale);
_context.SaveChanges();
return Json("ok"):
}回答 1
Stack Overflow用户
发布于 2018-07-09 08:32:34
在InvoiceSale实体中添加外键
public class InvoiceSale
{
public int Id { get; set; }
public int BudgetId { get; set; }
public int NumberInvoice { get; set; }
public DateTime InvoiceSaleDate { get; set; }
public Budget Budget { get; set; }
}
[HttpPost]
public ActionResult CreateInvoiceSale(InvoiceSale newInvoiceSale)
{
var invoiceSale = new InvoiceSale
{
BudgetId = newInvoiceSale.BudgetId,
NumberInvoice = newInvoiceSale.NumberInvoice,
InvoiceSaleDate = newInvoiceSale.InvoiceSaleDate,
//Here i need to pass the BudgetId value, but how can i do without a
//navigation property
};
_context.InvoiceSales.Add(invoiceSale);
_context.SaveChanges();
return Json("ok"):
}需要在InvoiceSale表中赋值，请使用此行BudgetId = newInvoiceSale.BudgetId,
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51236888
复制相关文章
相似问题
腾讯云开发者
