public bool EmployeeDepartmentHistoryDelete(EmployeeDepartmentHistory employeedepartmenthistory)
        {
            return Execute<bool>(dal =>
            {
                EmployeeDepartmentHistory employeedepartmenthistoryDelete = dal.EmployeeDepartmentHistory.Where(x => x.BusinessEntityID == employeedepartmenthistory.BusinessEntityID).FirstOrDefault();
                if (employeedepartmenthistoryDelete != null)
                {
                    dal.EmployeeDepartmentHistory.DeleteOnSubmit(employeedepartmenthistoryDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool EmployeeDepartmentHistoryUpdate(EmployeeDepartmentHistory employeedepartmenthistory)
        {
            return Execute<bool>(dal =>
               {
               EmployeeDepartmentHistory employeedepartmenthistoryUpdate = dal.EmployeeDepartmentHistory.Where(x => x.BusinessEntityID == employeedepartmenthistory.BusinessEntityID).FirstOrDefault();
               if (employeedepartmenthistoryUpdate != null)
               {
                   employeedepartmenthistoryUpdate.BusinessEntityID = employeedepartmenthistory.BusinessEntityID;
                   employeedepartmenthistoryUpdate.DepartmentID = employeedepartmenthistory.DepartmentID;
                   employeedepartmenthistoryUpdate.ShiftID = employeedepartmenthistory.ShiftID;
                   employeedepartmenthistoryUpdate.StartDate = employeedepartmenthistory.StartDate;
                   employeedepartmenthistoryUpdate.EndDate = employeedepartmenthistory.EndDate;
                   employeedepartmenthistoryUpdate.ModifiedDate = employeedepartmenthistory.ModifiedDate;
                   dal.SubmitChanges();
                   return true;
               }
               return false;

               });
        }
 partial void DeleteEmployeeDepartmentHistory(EmployeeDepartmentHistory instance);
 partial void UpdateEmployeeDepartmentHistory(EmployeeDepartmentHistory instance);
 partial void InsertEmployeeDepartmentHistory(EmployeeDepartmentHistory instance);
		private void detach_EmployeeDepartmentHistories(EmployeeDepartmentHistory entity)
		{
			this.SendPropertyChanging();
			entity.Department = null;
		}
 public void EmployeeDepartmentHistoryUpdate(EmployeeDepartmentHistory employeedepartmenthistory)
 {
     adventureWorks_BC.EmployeeDepartmentHistoryUpdate(employeedepartmenthistory);
 }