private static void InsertNewCompany(String input)
{
using (var context = new Context())
{
var company = new Company()
{
Name = input,
};
context.Companies.Add(company);
context.SaveChanges();
}
}
private static void InsertPerson(String firstName, String lastName)
{
using (var context = new Context())
{
var person = new Person
{
FirstName = firstName,
LastName = lastName
};
context.People.Add(person);
context.SaveChanges();
}
}
private static void DeleteData()
{
using (var context = new Context())
{
var personId = 2;
var person = context.People.Find(personId);
if (person != null)
{
context.People.Remove(person);
context.SaveChanges();
}
}
QueryData();
}
private static void UpdateData()
{
using (var context = new Context())
{
var savedPeople = context.People;
if (savedPeople.Any())
{
var person = savedPeople.First();
person.FirstName = "Johnny";
person.LastName = "Benson";
context.SaveChanges();
}
}
QueryData();
}