public bool ProductVendorUpdate(ProductVendor productvendor)
        {
            return Execute<bool>(dal =>
            {
                ProductVendor productvendorUpdate = dal.ProductVendor.Where(x => x.ProductID == productvendor.ProductID).FirstOrDefault();
                if (productvendorUpdate != null)
                {
                    productvendorUpdate.ProductID = productvendor.ProductID;
                    productvendorUpdate.BusinessEntityID = productvendor.BusinessEntityID;
                    productvendorUpdate.AverageLeadTime = productvendor.AverageLeadTime;
                    productvendorUpdate.StandardPrice = productvendor.StandardPrice;
                    productvendorUpdate.LastReceiptCost = productvendor.LastReceiptCost;
                    productvendorUpdate.LastReceiptDate = productvendor.LastReceiptDate;
                    productvendorUpdate.MinOrderQty = productvendor.MinOrderQty;
                    productvendorUpdate.MaxOrderQty = productvendor.MaxOrderQty;
                    productvendorUpdate.OnOrderQty = productvendor.OnOrderQty;
                    productvendorUpdate.UnitMeasureCode = productvendor.UnitMeasureCode;
                    productvendorUpdate.ModifiedDate = productvendor.ModifiedDate;

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

            });
        }
        public bool ProductVendorDelete(ProductVendor productvendor)
        {
            return Execute<bool>(dal =>
            {
                ProductVendor productvendorDelete = dal.ProductVendor.Where(x => x.ProductID == productvendor.ProductID).FirstOrDefault();
                if (productvendorDelete != null)
                {
                    dal.ProductVendor.DeleteOnSubmit(productvendorDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
		private void attach_ProductVendors(ProductVendor entity)
		{
			this.SendPropertyChanging();
			entity.Vendor = this;
		}
		private void detach_ProductVendors(ProductVendor entity)
		{
			this.SendPropertyChanging();
			entity.Vendor = null;
		}
 partial void DeleteProductVendor(ProductVendor instance);
 partial void UpdateProductVendor(ProductVendor instance);
 partial void InsertProductVendor(ProductVendor instance);
 public void ProductVendorUpdate(ProductVendor productvendor)
 {
     adventureWorks_BC.ProductVendorUpdate(productvendor);
 }
 public void ProductVendorAdd(ProductVendor productvendor)
 {
     adventureWorks_BC.ProductVendorAdd(productvendor);
 }