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