I am new to L2S and I want to update some fields in a table.
I have a parent DispositionHold table which has a PK of DispositionHoldID and a child table, Disposition with a PK DispositionID and FK DispositionHoldID.
I want to reference the child PK DispositionID in a where clause and I want to update the parent DispositionHold table.
One query I tried:
var updateHold =
(from dispositionHold in db.DispositionHolds
where dispositionHold.Dispositions.DispositionID == dispositionID
I can't do this because I can't get to dispositionHold.Dispositions.DispositionID. I can only get to dispositionHold.Dispositions and then I get a list of extension methods. How can I reference the PK of the child table?