public void AddPerson(Person person)
{
using (var context = new PeopleCarsDataContext(_connectionString))
{
context.People.Add(person);
context.SaveChanges();
}
}
public void AddCar(Car car)
{
using (var context = new PeopleCarsDataContext(_connectionString))
{
context.Cars.Add(car);
context.SaveChanges();
}
}
public void DeleteCarsForPerson(int personId)
{
using var context = new PeopleCarsDataContext(_connectionString);
var carsToDelete = context.Cars.Where(c => c.PersonId == personId);
context.Cars.RemoveRange(carsToDelete);
context.SaveChanges();
}
