public bool SpecialOfferProductDelete(SpecialOfferProduct specialofferproduct)
        {
            return Execute<bool>(dal =>
            {
                SpecialOfferProduct specialofferproductDelete = dal.SpecialOfferProduct.Where(x => x.SpecialOfferID == specialofferproduct.SpecialOfferID).FirstOrDefault();
                if (specialofferproductDelete != null)
                {
                    dal.SpecialOfferProduct.DeleteOnSubmit(specialofferproductDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool SpecialOfferProductUpdate(SpecialOfferProduct specialofferproduct)
        {
            return Execute<bool>(dal =>
            {
                SpecialOfferProduct specialofferproductUpdate = dal.SpecialOfferProduct.Where(x => x.SpecialOfferID == specialofferproduct.SpecialOfferID).FirstOrDefault();
                if (specialofferproductUpdate != null)
                {
                    specialofferproductUpdate.SpecialOfferID = specialofferproduct.SpecialOfferID;
                    specialofferproductUpdate.ProductID = specialofferproduct.ProductID;
                    specialofferproductUpdate.rowguid = specialofferproduct.rowguid;
                    specialofferproductUpdate.ModifiedDate = specialofferproduct.ModifiedDate;

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

            });
        }
 partial void InsertSpecialOfferProduct(SpecialOfferProduct instance);
		private void detach_SpecialOfferProducts(SpecialOfferProduct entity)
		{
			this.SendPropertyChanging();
			entity.SpecialOffer = null;
		}
		private void attach_SpecialOfferProducts(SpecialOfferProduct entity)
		{
			this.SendPropertyChanging();
			entity.Product = this;
		}
 partial void DeleteSpecialOfferProduct(SpecialOfferProduct instance);
 partial void UpdateSpecialOfferProduct(SpecialOfferProduct instance);
 public void SpecialOfferProductUpdate(SpecialOfferProduct specialofferproduct)
 {
     adventureWorks_BC.SpecialOfferProductUpdate(specialofferproduct);
 }