private static void QueryCompanies()
{
using (var context = new Context())
{
foreach (var company in context.Companies)
{
Console.WriteLine("C.id: {0}, Company Name: {1}",
company.CompanyId, company.Name);
}
}
}
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 QueryData()
{
using (var context = new Context())
{
var savedPeople = context.People;
foreach (var person in savedPeople)
{
Console.WriteLine("id: {0}, Firstname: {1}, Lastname: {2}",
person.PersonId, person.FirstName, person.LastName);
}
}
}
private static void VerifyDatabaseExists()
{
using (var context = new Context())
{
context.Database.CreateIfNotExists();
}
}
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();
}