Unable to remove the row from table in which foreign key exists in MVC

Question

Hello,

In my mvc application I have 2 tables named: detail(srNo, ID, work), master(ID, name,plan) that are related with foreign key relation ship from detail to master using "ID" field. "ID" field is primary key of master table. "srNo" field is primary key of detail table.

From the "ID" field, this 2 tables are joined with foreign key relation ship.

Now the Problem is: While adding any row to database, we are first make entry in master table , then in details table. And sometimes due to some exception, when row is succesfully added in master table but can not add in detail table. Then I want to perform rollback from master table.

But when I want to delete the row with recently added ID value (grom linq to sql), which is added in master table it is giving me exception that forign key realtion ship is there .....

And at that time in detail table there is no row of that id field.

Thanks

Answer 1

it seams that data is inserted in child table also. first you have to delete from detail table using deleteallonsubmit(detail) and then from the master table. can you explain what is meant by exception, is it error or your validation

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();  
        }

}

Answer 2

Here is the code

master objmaster= new master(); objmaster.id =count; 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; // 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); objEntities.SaveChanges(); } catch(Exception ex) {

//Here i want to delete the row which I have added in master table: // I write the code for this master objMasters= (from r in objEntities.master where r.Id == count select r).ToList(); objEntities.DeleteObject(objMasters); objEntities.SaveChanges(); }