Are you using LINQ to SQL ?
If so, you can easily get the Enumerable of recordes that you want to delete and then use RemoveAll method on the Table to remove all the records present in the Enumerable.
var recordstodelete = from x in emp where emp.jobid = 2 select x;
now after you get this call:
dbml.Emp.RemoveAll(recordtodelete);
dbml.SubmitChanges();
this is all u need.
:)