private void btnSave_Click(object sender, EventArgs e) { using (DealershipManagerEntities context = new DealershipManagerEntities()) { if (currentInsuranceCompany != null) { //It exists, find it, and edit it. InsuranceCompany insuranceCompany = (from insCompany in context.InsuranceCompanies where insCompany.CompanyId == currentInsuranceCompany.CompanyId select insCompany).FirstOrDefault(); updateInsuranceCompany(insuranceCompany); context.SaveChanges(); context.Connection.Close(); } else { InsuranceCompany insuranceCompany = new InsuranceCompany(); updateInsuranceCompany(insuranceCompany); context.InsuranceCompanies.AddObject(insuranceCompany); context.SaveChanges(); context.Connection.Close(); } } MessageBox.Show("Insurance Company has been saved"); customerForm.insuranceCompanyTableAdapter.Fill(customerForm.dealershipManagerDataSet.InsuranceCompany); customerForm.cboInsuranceCompany.SelectedItem = currentInsuranceCompany; customerForm.currentInsuranceCompany = currentInsuranceCompany; customerForm.BindInsuranceCompanyToForm(); this.Close(); }