public List <Parking> GetParkings(int carId) { using var context = new CarParkingContext(); return(context.Cars.Join(context.CarParkings, car => car.Id, carParking => carParking.CarId, (c, cp) => new { car = c, carParking = cp }).Join(context.Parkings, t2 => t2.carParking.ParkingId, parking => parking.Id, (t3, k) => new { car = t3.car, parking = k, carParking = t3.carParking }).Where(I => I.car.Id == carId).Select(I => new Parking { Section = I.parking.Section, Id = I.parking.Id }).ToList()); }
public List <Table> GetAllData() { using var context = new CarParkingContext(); return(context.Set <Table>().ToList()); }
public Table GetWithIdParkings(int id) { using var context = new CarParkingContext(); return(context.Set <Table>().Find(id)); }
public void Remove(Table table) { using var context = new CarParkingContext(); context.Set <Table>().Remove(table); context.SaveChanges(); }