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(); }