public bool ProductReviewDelete(ProductReview productreview)
        {
            return Execute<bool>(dal =>
            {
                ProductReview productreviewDelete = dal.ProductReview.Where(x => x.ProductReviewID == productreview.ProductReviewID).FirstOrDefault();
                if (productreviewDelete != null)
                {
                    dal.ProductReview.DeleteOnSubmit(productreviewDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool ProductReviewUpdate(ProductReview productreview)
        {
            return Execute<bool>(dal =>
            {
                ProductReview productreviewUpdate = dal.ProductReview.Where(x => x.ProductReviewID == productreview.ProductReviewID).FirstOrDefault();
                if (productreviewUpdate != null)
                {
                    productreviewUpdate.ProductReviewID=productreview.ProductReviewID;
            productreviewUpdate.ProductID=productreview.ProductID;
            productreviewUpdate.ReviewerName=productreview.ReviewerName;
            productreviewUpdate.ReviewDate=productreview.ReviewDate;
            productreviewUpdate.EmailAddress=productreview.EmailAddress;
            productreviewUpdate.Rating=productreview.Rating;
            productreviewUpdate.Comments=productreview.Comments;
            productreviewUpdate.ModifiedDate=productreview.ModifiedDate;

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

            });
        }
		private void detach_ProductReviews(ProductReview entity)
		{
			this.SendPropertyChanging();
			entity.Product = null;
		}
		private void attach_ProductReviews(ProductReview entity)
		{
			this.SendPropertyChanging();
			entity.Product = this;
		}
 partial void DeleteProductReview(ProductReview instance);
 partial void UpdateProductReview(ProductReview instance);
 partial void InsertProductReview(ProductReview instance);
 public void ProductReviewUpdate(ProductReview productreview)
 {
     adventureWorks_BC.ProductReviewUpdate(productreview);
 }
 public void ProductReviewAdd(ProductReview productreview)
 {
     adventureWorks_BC.ProductReviewAdd(productreview);
 }