public Person GetById(int id) { using (var context = new PeopleCarsDataContext(_connectionString)) { return(context.People.FirstOrDefault(p => p.Id == id)); } }
public List <Car> GetCars(int personId) { using (var context = new PeopleCarsDataContext(_connectionString)) { return(context.Cars.Where(c => c.PersonId == personId).ToList()); } }
public List <Person> GetPeople() { using (var context = new PeopleCarsDataContext(_connectionString)) { return(context.People.Include(p => p.Cars).ToList()); } }
public void AddCar(Car car) { using (var context = new PeopleCarsDataContext(_connectionString)) { context.Cars.Add(car); context.SaveChanges(); } }
public void AddPerson(Person person) { using (var context = new PeopleCarsDataContext(_connectionString)) { context.People.Add(person); 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(); }
public int GetRandomPersonId() { using var context = new PeopleCarsDataContext(_connectionString); return(context.People.ToList().OrderBy(_ => new Random().Next()).First().Id); }