public void Update(DS_Employees Employees) { using (var ct = new DS_EmployeesDataContext(DbHelperSQL.Connection)) { ct.DS_Employees.Attach(Employees, true); ct.SubmitChanges(); } }
public void Add(DS_Employees Employees) { using (var ct = new DS_EmployeesDataContext(DbHelperSQL.Connection)) { ct.DS_Employees.InsertOnSubmit(Employees); ct.SubmitChanges(); } }
public void Delete(int ID) { using (var ct = new DS_EmployeesDataContext(DbHelperSQL.Connection)) { DS_Employees st = ct.DS_Employees.Single(a => a.ID == ID); ct.DS_Employees.DeleteOnSubmit(st); ct.SubmitChanges(); } }