public IList <Vehicle> GetAll() { VehicleDBEntities db = new VehicleDBEntities(); try { var vehQuery = from veh in db.VehicleModelYear select veh; var ret = vehQuery.Select(vh => new Vehicle() { Id = vh.id, Manufacturer = vh.make, Model = vh.model, Year = vh.year }).ToList(); //Lets only return 1000 records return(ret); } finally { db.Dispose(); } }
public override IEnumerable <Vehicle> Get(int page, int size) { int skip = page == 1 ? 0 : (page - 1) * size + 1; VehicleDBEntities db = new VehicleDBEntities(); try { var vehQuery = db.VehicleModelYear.OrderBy(vmy => vmy.id).Skip(skip).Take(size); var ret = vehQuery.Select(vh => new Vehicle() { Id = vh.id, Manufacturer = vh.make, Model = vh.model, Year = vh.year }).ToList(); //Lets only return 1000 records return(ret); } finally { db.Dispose(); } }
public override Vehicle Get(int id) { VehicleDBEntities db = new VehicleDBEntities(); try { var vehQuery = from veh in db.VehicleModelYear where veh.id == id select veh; var vehicle = vehQuery.Select(vh => new Vehicle() { Id = vh.id, Manufacturer = vh.make, Model = vh.model, Year = vh.year }).ToList().FirstOrDefault(); return(vehicle); } finally { db.Dispose(); } }