public Program Get(int id) { var filter = new ProgramFilter() { Id = id }; return GetPrograms(filter).FirstOrDefault(); }
private List<Program> GetPrograms(ProgramFilter filter) { using (var db = DataFactory.GetRemoteEntities()) { var query = db.Programs.AsQueryable(); //add filters if (filter.Id.HasValue) { query = query.Where(program => program.Id == filter.Id.Value); } //include other tables if single select if (filter.Id.HasValue) { query = query.Include(p => p.Remote); } return query.ToList(); } }
public List<Program> GetAll() { var filter = new ProgramFilter(); return GetPrograms(filter); }