public bool ProductModelDelete(ProductModel productmodel)
        {
            return Execute<bool>(dal =>
            {
                ProductModel productmodelDelete = dal.ProductModel.Where(x => x.ProductModelID == productmodel.ProductModelID).FirstOrDefault();
                if (productmodelDelete != null)
                {
                    dal.ProductModel.DeleteOnSubmit(productmodelDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool ProductModelUpdate(ProductModel productmodel)
        {
            return Execute<bool>(dal =>
            {
                ProductModel productmodelUpdate = dal.ProductModel.Where(x => x.ProductModelID == productmodel.ProductModelID).FirstOrDefault();
                if (productmodelUpdate != null)
                {
                    productmodelUpdate.ProductModelID = productmodel.ProductModelID;
                    productmodelUpdate.Name = productmodel.Name;
                    productmodelUpdate.CatalogDescription = productmodel.CatalogDescription;
                    productmodelUpdate.Instructions = productmodel.Instructions;
                    productmodelUpdate.rowguid = productmodel.rowguid;
                    productmodelUpdate.ModifiedDate = productmodel.ModifiedDate;

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

            });
        }
 partial void DeleteProductModel(ProductModel instance);
 partial void UpdateProductModel(ProductModel instance);
 partial void InsertProductModel(ProductModel instance);
 public void ProductModelUpdate(ProductModel productmodel)
 {
     adventureWorks_BC.ProductModelUpdate(productmodel);
 }
 public void ProductModelAdd(ProductModel productmodel)
 {
     adventureWorks_BC.ProductModelAdd(productmodel);
 }