I keep forgetting how to do this in LINQPad so I’m making a note of it here. The scenario is that I had a table called Qualifiers and wanted to delete several rows in it which had an ID beginning “ts”. The following code will filter out those rows into a collection then delete them when SubmitChanges is called.

Qualifiers.DeleteAllOnSubmit(from q in Qualifiers where q.Id.StartsWith(“ts”) select q);