public bool ShipMethodDelete(ShipMethod shipmethod)
        {
            return Execute<bool>(dal =>
            {
                ShipMethod shipmethodDelete = dal.ShipMethod.Where(x => x.ShipMethodID == shipmethod.ShipMethodID).FirstOrDefault();
                if (shipmethodDelete != null)
                {
                    dal.ShipMethod.DeleteOnSubmit(shipmethodDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool ShipMethodUpdate(ShipMethod shipmethod)
        {
            return Execute<bool>(dal =>
               {
               ShipMethod shipmethodUpdate = dal.ShipMethod.Where(x => x.ShipMethodID == shipmethod.ShipMethodID).FirstOrDefault();
               if (shipmethodUpdate != null)
               {
                   shipmethodUpdate.ShipMethodID = shipmethod.ShipMethodID;
                   shipmethodUpdate.Name = shipmethod.Name;
                   shipmethodUpdate.ShipBase = shipmethod.ShipBase;
                   shipmethodUpdate.ShipRate = shipmethod.ShipRate;
                   shipmethodUpdate.rowguid = shipmethod.rowguid;
                   shipmethodUpdate.ModifiedDate = shipmethod.ModifiedDate;

                   dal.SubmitChanges();
                   return true;
               }
               return false;

               });
        }
 partial void DeleteShipMethod(ShipMethod instance);
 partial void UpdateShipMethod(ShipMethod instance);
 partial void InsertShipMethod(ShipMethod instance);
 public void ShipMethodUpdate(ShipMethod shipmethod)
 {
     adventureWorks_BC.ShipMethodUpdate(shipmethod);
 }
 public void ShipMethodAdd(ShipMethod shipmethod)
 {
     adventureWorks_BC.ShipMethodAdd(shipmethod);
 }