public bool ProductDescriptionDelete(ProductDescription productdescription)
        {
            return Execute<bool>(dal =>
            {
                ProductDescription productdescriptionDelete = dal.ProductDescription.Where(x => x.ProductDescriptionID == productdescription.ProductDescriptionID).FirstOrDefault();
                if (productdescriptionDelete != null)
                {
                    dal.ProductDescription.DeleteOnSubmit(productdescriptionDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool ProductDescriptionUpdate(ProductDescription productdescription)
        {
            return Execute<bool>(dal =>
            {
                ProductDescription productdescriptionUpdate = dal.ProductDescription.Where(x => x.ProductDescriptionID == productdescription.ProductDescriptionID).FirstOrDefault();
                if (productdescriptionUpdate != null)
                {
                    productdescriptionUpdate.ProductDescriptionID=productdescription.ProductDescriptionID;
            productdescriptionUpdate.Description=productdescription.Description;
            productdescriptionUpdate.rowguid=productdescription.rowguid;
            productdescriptionUpdate.ModifiedDate=productdescription.ModifiedDate;

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

            });
        }
 partial void DeleteProductDescription(ProductDescription instance);
 partial void UpdateProductDescription(ProductDescription instance);
 partial void InsertProductDescription(ProductDescription instance);
 public void ProductDescriptionUpdate(ProductDescription productdescription)
 {
     adventureWorks_BC.ProductDescriptionUpdate(productdescription);
 }
 public void ProductDescriptionAdd(ProductDescription productdescription)
 {
     adventureWorks_BC.ProductDescriptionAdd(productdescription);
 }