在我的mvc应用程序中,我有两个表: detail(srNo,ID,work),master(ID,name,plan),它们使用"ID“字段与从细节到主的外键关系关联。ID字段是主表的主键。srNo字段为明细表的主键。
从"ID“字段开始,这两个表通过外键关系连接在一起。
现在的问题是:在向数据库添加任何行时,我们首先在主表中创建条目,然后在明细表中创建条目。有时由于某些例外,在主表中成功添加行,但无法在明细表中添加行。然后我想从主表执行回滚。
但是当我想要删除最近添加了ID值的行(grom linq to sql),这是在主表中添加的,它给我的异常是外键关系ship在那里.....
并且此时在详细信息表中没有该id字段的行。
谢谢
发布于 2010-10-01 20:27:37
它认为数据也被插入到子表中。首先,您必须使用deleteallonsubmit( detail )从细节表中删除,然后再从主表中删除。你能解释一下异常是什么意思吗?是错误还是你的验证
public ActionResult CreateRec(Master _Master, IEnumerable<Detail> Detaildata,FormCollection collection)
{
MasterRepo _MasterRepo = new MasterRepo();
if (ModelState.IsValid)
{
if (_detail != null)
{
foreach (var objdetail in DetailData)
{
Detail _Detail = new Detail();
_Detail.FirstField = objdetail.FirstField;
_Detail.SecondField = objdetail.SecondtField;
_Master.Detail.Add(_Detail);
}
}
_MasterRepo.Save();
}
}发布于 2010-10-01 22:11:18
以下是代码
主机新主机();objmaster.id = objmaster=;objmaster.name= name1;..objEntities.AddObject(" master ",objmaster);objEntities.SaveChanges();try { detail objDetail = new detail() master objMaster = (from r in objEntities.master where r.Id == count select r).First();objDetail.master = objMaster;//假设我得到了any (format,此处为空指针异常) objDetail.folow =sfield;//如果发生异常,下面的代码将不会被执行
objEntities.AddObject("detail",objDetail);objEntities.SaveChanges();} catch(Exception ex) {
//在这里我想删除我在主表中添加的行://我为这个主表写代码(from r in objEntities.master where r.Id == objMasters= .ToList r).ToList();objEntities.DeleteObject(objMasters);objEntities.SaveChanges();}
发布于 2013-10-25 03:18:06
我认为你需要同时提交这两个文件,这样它们才能在同一事务中。这样就不需要编写回滚代码,因为如果详细信息失败,则不会插入主代码。试着这样做:
master objmaster= new master();
objmaster.id =count;
objmaster.name= name1;
..
objEntities.AddObject("master", objmaster);
// == removed save changes call here ==
detail objDetail = new detail()
// == no need to reselect master from the database, you already have it
// == so just assign it, and that will take care of the references/foreign-key
objDetail.master = objMaster; // Suppose I get any (format, null pointer exception here)
objDetail.folow = sfields[0]; //In case of exception this below code will not be excecuted
objEntities.AddObject("detail", objDetail);
// == save at the end ==
objEntities.SaveChanges(); https://stackoverflow.com/questions/3838463
复制相似问题