Remove data from linq relation

Question

If i have a sq-table relation model that looks like this:

Project <----> ProjectActivity <----> Activity

Where Project and Activity has many to many connections via ProjectActivity and i want to remove a ProjectActivity (not just set its Projekt FK to null). How to i do this?

If I on the EntitySet takes Project.ProjectActivities.Clear(); the relation will be deletet but the ProjectActivity row will still be there with null reference to Project.

Answer 1

dataContext.ProjectActivities.DeleteAllOnSubmit(Project.ProjectActivities); 

that should work, you have to delete them not just clear relations