How to remove all children using linq in sql?

Question

Is there an easy way to remove all child records for an element using Linq in sql?

+5

Abe miessler Aug 9 '10 at 16:48

1 answer

kbrimington · Accepted Answer · 2010-08-09T16:53:33+0000

Something like this will work if there is a relationship between the tables:

var parent = // ...
context.Children.DeleteAllOnSubmit(parent.Children);
context.SubmitChanges();