Hi there, if you're using a DataContext of some sort you can use the following. Substitute 'DataContext' with the name of your data context, and 'TableName' with the name of the table you're deleting from.
using System.Linq;
using (DataContext dc = new DataContext())
{
var deletedCustomer = (from c in dc.TableName
where c.customer_id == CustID
select c).Single();
try
{
dc.TableName.DeleteOnSubmit(deletedCustomer);
dc.SubmitChanges();
}
catch (Exception ex)
{
}
}