实体框架SaveChanges（）在不同的DbContext中插入不必要的行
||
我的超市模型包含一个StockItem类和一个包含StockItem字段的Alert类：
public class StockItem
{
public int ID { get; set; }
public string Name { get; set; }
public int CurrentQuantity { get; set; }
public int MinQuantity { get; set; }
}
public class Alert
{
public int ID { get; set; }
public int Message{ get; set; }
public virtual StockItem StockItem { get; set; }
}
using (var db = new MyDbContext())
{
return db.StockItems.ToList();
}
foreach (var item in items)
{
if (item.CurrentQuantity < item.MinQuantity)
{
using (var db = new MyDbContext())
{
db.Alerts.Add(new Alert(){StockItem = item, Message = \"Low Quantity\"});
db.SaveChanges();
}
}
}
没有找到相关结果
已邀请:
2 个回复
抹持奠糙驰
foreach (var item in items) { if (item.CurrentQuantity < item.MinQuantity) { using (var db = new MyDbContext()) { db.StockItems.Attach(item); db.Alerts.Add(new Alert {StockItem = item, Message = \"Low Quantity\"}); db.SaveChanges(); } } }弛保矮瘦敖
using (var db = new MyDbContext()) { var items = db.StockItems.ToList(); foreach (var item in items) { if (item.CurrentQuantity < item.MinQuantity) { db.Alerts.Add(new Alert {StockItem = item, Message = \"Low Quantity\"}); db.SaveChanges(); } } }using (var db = new MyDbContext()) { return db.StockItems.ToList(); }