public List <Car> GetCarsById(int id)
{
using (var context = new PeopleCarContext(_connection))
{
return(context.Cars.Where(c => c.PersonId == id).ToList());
}
}
public Person GetPersonById(int id)
{
using (var context = new PeopleCarContext(_connection))
{
return(context.People.FirstOrDefault(p => p.Id == id));
}
}
public List <Person> GetPeopleWithCars()
{
using (var context = new PeopleCarContext(_connection))
{
return(context.People.Include(p => p.Cars).ToList());
}
}
public void DeleteCars(int id)
{
using (var context = new PeopleCarContext(_connection))
{
context.RemoveRange(context.Cars.Where(c => c.PersonId == id));
context.SaveChanges();
}
}
public void AddCar(Car c)
{
using (var context = new PeopleCarContext(_connection))
{
context.Cars.Add(c);
context.SaveChanges();
}
}
public void AddPerson(Person p)
{
using (var context = new PeopleCarContext(_connection))
{
context.People.Add(p);
context.SaveChanges();
}
}