private void customersSaveButton_Click(object sender, EventArgs e) { var companyNameArg = customerCompanyName.Text.Trim(); var descriptionArg = customerDescription.Text.Trim(); var passwordArg = customerPassword.Text; try { if (customersSaveMode) { customerToModify = new Customer { CompanyName = companyNameArg, Description = descriptionArg, Password = passwordArg, }; if (context.Customers.Any(c => c.CompanyName == companyNameArg)) { showErrorMessageBox("Company name is already taken."); } else { context.Customers.Add(customerToModify); showSuccessMessageBox("Customer added."); } } else { customerToModify.CompanyName = companyNameArg; customerToModify.Description = descriptionArg; customerToModify.Password = passwordArg; context.Entry(customerToModify).State = EntityState.Modified; showSuccessMessageBox("Customer updated."); } context.SaveChanges(); } catch (Exception ex) { showErrorMessageBox(); Console.WriteLine("Exception while saving customer: " + ex.Message); } customersGridView.Refresh(); customersClear(); }
static void ShowProducts_NavigationProperties() { using (var ctx = new ProdContext()) { Console.WriteLine("Available products:"); foreach (Product p in ctx.Products) { ctx.Entry(p).Reference(pr => pr.Category).Load(); if (null != p.Category) { Console.WriteLine("{0} {1} belongs to category {2}", p.ProductID, p.Name, p.Category.Name); } else { Console.WriteLine("{0} {1} does not belong to any category", p.ProductID, p.Name, p.Category.Name); } } } }