public IEnumerable <CarModel> GetAvailableCars() { // select all cars that are not in the purchased table return(from c in cars where !(from p in purchases select p.VehicleId) .Contains(c.Id) select CarModel.FromCar(c)); }
public IEnumerable <CarModel> GetAllCars() { return(from c in cars join b in bodies on c.Body.BodyId equals b.BodyId join i in interiors on c.Interior.InteriorId equals i.InteriorId join col in colors on c.CarColor.ColorId equals col.ColorId join coli in colors on c.InteriorColor.ColorId equals coli.ColorId join t in transmissions on c.Transmission.TransmissionId equals t.TransmissionId join mo in models on c.MakeModel.ModelId equals mo.ModelId join ma in makes on mo.Make.MakeId equals ma.MakeId select CarModel.FromCar(c)); }
public CarModel GetCarById(int id) { return(( from c in cars where c.Id == id join b in bodies on c.Body.BodyId equals b.BodyId join i in interiors on c.Interior.InteriorId equals i.InteriorId join col in colors on c.CarColor.ColorId equals col.ColorId join coli in colors on c.InteriorColor.ColorId equals coli.ColorId join t in transmissions on c.Transmission.TransmissionId equals t.TransmissionId join mo in models on c.MakeModel.ModelId equals mo.ModelId join ma in makes on mo.Make.MakeId equals ma.MakeId select CarModel.FromCar(c) ).FirstOrDefault()); }