111,094
社区成员




[Key]
[StringLength(150)]
public string Id { get; set; }
[ForeignKey("Material")]
public string MaterialNo { get; set; }
public virtual Material Material { get; set; }
[ForeignKey("Supplier")]
public int SupplierId { get; set; }
public virtual Supplier Supplier { get; set; }
var MaterialWithSupplier = db.MaterialWithSuppliers.Where(m => m.MaterialNo == MaterialNo).ToList();
if (MaterialWithSupplier.Count > 0) db.MaterialWithSuppliers.Remove(MaterialWithSupplier[0]);
这样做了,但是这一操作把MaterialWithSupplier表中所有记录给删除了,我觉得很是奇怪,希望各位大大帮帮我,到底是啥原因啊?愁死我了!modelBuilder.Entity<Material>().MapToStoredProcedures();
可是我看了下生成的迁移也没什么问题 CreateStoredProcedure(
"dbo.Material_Delete",
p => new
{
MaterialNo = p.String(maxLength: 50, unicode: false, storeType: "nvarchar"),
},
body:
@"DELETE FROM `t_material` WHERE `MaterialNo` = @MaterialNo;"
);
,如果有谁知道希望能教小弟一下,在此谢过!当然,非常感谢楼上两位兄弟的热心帮助,尤其是@无Model不MVC! var Material = db.Materials.Where(m => m.MaterialNo == MaterialNo).ToList();
if (Material.Count == 0)
{
return "找不到該材料,可能已經被刪除!";
}
else
{
try
{
db.Materials.Remove(Material[0]);
db.SaveChanges();
}
var Material = db.Materials.Where(m => m.MaterialNo == MaterialNo).ToList();
if (Material.Count == 0)
{
return "找不到該材料,可能已經被刪除!";
}
else
{
try
{
db.Materials.Remove(Material[0]);
db.SaveChanges();
}
catch (DataException/* dex */ e)
{
//Log the error (uncomment dex variable name and add a line here to write a log.
return e.InnerException.InnerException.Message;
}
还望大神能指导下!非常感激了!