public void DeleteCars(int personId) { using var contex = new PeopleCarsContext(_connectionString); contex.Database.ExecuteSqlInterpolated($"DELETE FROM Cars WHERE PersonId = {personId}"); }
public void AddCar(Car car) { using var context = new PeopleCarsContext(_connectionString); context.Cars.Add(car); context.SaveChanges(); }
public List <Car> GetCarsForPerson(int personId) { using var context = new PeopleCarsContext(_connectionString); return(context.Cars.Where(c => c.PersonId == personId).ToList()); }
public Person GetPerson(int id) { using var context = new PeopleCarsContext(_connectionString); return(context.People.FirstOrDefault(p => p.Id == id)); }
public List <Person> GetPeople() { using var context = new PeopleCarsContext(_connectionString); return(context.People.Include(c => c.Cars).ToList()); }
public void AddPerson(Person person) { using var context = new PeopleCarsContext(_connectionString); context.People.Add(person); context.SaveChanges(); }