public List <Car> GetCarById(int id)
{
using var context = new PeopleDataContext(_connectionString);
return((List <Car>)context.Cars.Where(c => c.PersonId == id));
}
public void DeleteCars(int id)
{
using var context = new PeopleDataContext(_connectionString);
context.Cars.RemoveRange(context.Cars.Where(c => c.PersonId == id));
context.SaveChanges();
}
public void Add(Car car)
{
using var context = new PeopleDataContext(_connectionString);
context.Cars.Add(car);
context.SaveChanges();
}
public List <Person> GetAllPeople()
{
using var context = new PeopleDataContext(_connectionString);
return(context.People.Include(c => c.Cars).ToList());
}
public void Add(Person person)
{
using var context = new PeopleDataContext(_connectionString);
context.People.Add(person);
context.SaveChanges();
}
