public bool ProductPhotoDelete(ProductPhoto productphoto)
        {
            return Execute<bool>(dal =>
            {
                ProductPhoto productphotoDelete = dal.ProductPhoto.Where(x => x.ProductPhotoID == productphoto.ProductPhotoID).FirstOrDefault();
                if (productphotoDelete != null)
                {
                    dal.ProductPhoto.DeleteOnSubmit(productphotoDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool ProductPhotoUpdate(ProductPhoto productphoto)
        {
            return Execute<bool>(dal =>
            {
                ProductPhoto productphotoUpdate = dal.ProductPhoto.Where(x => x.ProductPhotoID == productphoto.ProductPhotoID).FirstOrDefault();
                if (productphotoUpdate != null)
                {
                    productphotoUpdate.ProductPhotoID = productphoto.ProductPhotoID;
                    productphotoUpdate.ThumbNailPhoto = productphoto.ThumbNailPhoto;
                    productphotoUpdate.ThumbnailPhotoFileName = productphoto.ThumbnailPhotoFileName;
                    productphotoUpdate.LargePhoto = productphoto.LargePhoto;
                    productphotoUpdate.LargePhotoFileName = productphoto.LargePhotoFileName;
                    productphotoUpdate.ModifiedDate = productphoto.ModifiedDate;

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

            });
        }
 partial void DeleteProductPhoto(ProductPhoto instance);
 partial void UpdateProductPhoto(ProductPhoto instance);
 partial void InsertProductPhoto(ProductPhoto instance);
 public void ProductPhotoUpdate(ProductPhoto productphoto)
 {
     adventureWorks_BC.ProductPhotoUpdate(productphoto);
 }
 public void ProductPhotoAdd(ProductPhoto productphoto)
 {
     adventureWorks_BC.ProductPhotoAdd(productphoto);
 }