>表
Product
-Id (PK)
-Name
ProductExtension
-ProductId (PK)
-Notes
分配和插入记录
Product product = new Product();
product.Name = "Phone";
ProductExtension = productExtension = new ProductExtension();
productExtension.ProductId = product.Id;
productExtension.Notes = "some notes";
//Add and save
context.Products.Add(product);
context.ProductExtensions.Add(productExtension);
context.SaveChangesAsync();
错误:
PostgresException: 23503:在表"product_extension"上插入或更新违反外键约束"FK_product_extension_product_product_id">
因此,不会首先创建产品并将产品 ID 分配给productextesion.productid?
我是否需要为每个表执行Add
和SaveChanges
? :(
使用导航属性或保存之前,以便 EF Core 可以填充主键(仅在保存实体后发生(。
public class ProductExtension
{
public int ProductId { get; set; }
public Product Product { get; set; }
public string Notes { get; set; }
}
现在您可以使用
Product product = new Product();
product.Name = "Phone";
ProductExtension = productExtension = new ProductExtension();
// assign the whole model to the navigation property
productExtension.Product = product;
productExtension.Notes = "some notes";
// no need for this anymore
// context.Products.Add(product);
//Add and save
context.ProductExtensions.Add(productExtension);
context.SaveChangesAsync();