public bool ProductSubcategoryDelete(ProductSubcategory productsubcategory)
        {
            return Execute<bool>(dal =>
            {
                ProductSubcategory productsubcategoryDelete = dal.ProductSubcategory.Where(x => x.ProductSubcategoryID == productsubcategory.ProductSubcategoryID).FirstOrDefault();
                if (productsubcategoryDelete != null)
                {
                    dal.ProductSubcategory.DeleteOnSubmit(productsubcategoryDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool ProductSubcategoryUpdate(ProductSubcategory productsubcategory)
        {
            return Execute<bool>(dal =>
            {
                ProductSubcategory productsubcategoryUpdate = dal.ProductSubcategory.Where(x => x.ProductSubcategoryID == productsubcategory.ProductSubcategoryID).FirstOrDefault();
                if (productsubcategoryUpdate != null)
                {
                    productsubcategoryUpdate.ProductSubcategoryID = productsubcategory.ProductSubcategoryID;
                    productsubcategoryUpdate.ProductCategoryID = productsubcategory.ProductCategoryID;
                    productsubcategoryUpdate.Name = productsubcategory.Name;
                    productsubcategoryUpdate.rowguid = productsubcategory.rowguid;
                    productsubcategoryUpdate.ModifiedDate = productsubcategory.ModifiedDate;

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

            });
        }
		private void detach_ProductSubcategories(ProductSubcategory entity)
		{
			this.SendPropertyChanging();
			entity.ProductCategory = null;
		}
 partial void DeleteProductSubcategory(ProductSubcategory instance);
 partial void UpdateProductSubcategory(ProductSubcategory instance);
 partial void InsertProductSubcategory(ProductSubcategory instance);
 public void ProductSubcategoryDelete(ProductSubcategory productsubcategory)
 {
     adventureWorks_BC.ProductSubcategoryDelete(productsubcategory);
 }
 public void ProductSubcategoryAdd(ProductSubcategory productsubcategory)
 {
     adventureWorks_BC.ProductSubcategoryAdd(productsubcategory);
 }