When we save a updated entity, this result into a SQL statement doesn't return rows error?
The entity has assocations.
Why do you declare a temp table for updating a record?
Code: Select all
DECLARE @tempVar TABLE(ContainerID INT); update dbo.Moves set VerhuurOrderID = @P1 OUTPUT INSERTED.ContainerID INTO @tempVar where ID = @P2',N'@P1 int,@P2 int',3,33
Code: Select all
aMove.VerhuurOrderID := aVerhuurOrder.ID;
DataContext.Save(aMove); // SQL statement doens't return rows.
Code: Select all
//aMove.VerhuurOrderID := aVerhuurOrder.ID;
DataContext.Save(aMove); // Update succes