Devart Forums

Code: Select all

using (var ctx = new MyDataContext())
{
       var contractdoc = ctx.Contractdocs.First();
       var newApproval = new Approveprocess(){Location = ctx.Locations.First(), Approvalstate = ctx.Locations().First(), Enterstateat = DateTime.Today};
       contractdoc.Approvalprocess.Add(newApproval);
	ctx.SumbmitChanges();

	newApproval.Location = ctx.Locations.Single(x=>x.Id == 2);	contractdoc.Approvalprocess.Remove(newApproval); // Property 'Delete on Null' for the relation between Contractdoc and Approvalprocess sets to True       
	ctx.SumbmitChanges(); // Exception: Test method MTests.ContractApprovalViewModelTest.TestRemoveApprovalAfterEdit threw exception: 
Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.Oracle.OracleException: ORA-02291: integrity constraint (UD.FKAPPROVALPR530332) violated - parent key not found
        	
}

Code: Select all

UPDATE UD.APPROVALPROCESS SET CONTRACTDOCID = :p1, LOCATIONID = :p2 WHERE ID = :key1 AND CONTRACTDOCID = :chk1 AND LOCATIONID = :chk2 AND APPROVALSTATEID = :chk3 AND ENTERSTATEAT = :chk4 AND ((:nullchk5 = 1 AND MISSIVEID IS NULL) OR (MISSIVEID = :chk5)) AND ((:nullchk6 = 1 AND MISSIVEDATE IS NULL) OR (MISSIVEDATE = :chk6)) AND ((:nullchk7 = 1 AND DESCRIPTION IS NULL) OR (DESCRIPTION = :chk7))
-- p1: Input Number (Size = 0; DbType = Decimal) [0]
-- p2: Input Number (Size = 0; DbType = Decimal) [2]
-- key1: Input Number (Size = 0; DbType = Decimal) [10022]
-- chk1: Input Number (Size = 0; DbType = Decimal) [1]
-- chk2: Input Number (Size = 0; DbType = Decimal) [-1]
-- chk3: Input Number (Size = 0; DbType = Decimal) [-1]
-- chk4: Input Date (Size = 0; DbType = DateTime) [08.07.2011 0:00:00]
-- nullchk5: Input Integer (Size = 0; DbType = Int32) [1]
-- chk5: Input NVarChar (Size = 0; DbType = String) []
-- nullchk6: Input Integer (Size = 0; DbType = Int32) [1]
-- chk6: Input Date (Size = 0; DbType = DateTime) []
-- nullchk7: Input Integer (Size = 0; DbType = Int32) [1]
-- chk7: Input NVarChar (Size = 0; DbType = String) []
-- Context: Devart.Data.Oracle.Linq.Provider.OracleDataProvider Model: ao Build: 2.50.25.0

DELETE FROM ApprovalProcess
-- Context: Devart.Data.Oracle.Linq.Provider.OracleDataProvider Model: ao Build: 2.50.25.0