public DataResponse <EntityList <EntitySelectItem> > GetPracticeTypes() { var response = new DataResponse <EntityList <EntitySelectItem> >(); try { var cachedData = response.GetCached <EntityList <EntitySelectItem> >(CacheKeys.PracticeTypes); if (cachedData.IsOk()) { return(cachedData); } base.DBInit(); var query = DBEntity.LookupPracticeTypes.Where(s => s.IsActive == true).Select(s => new EntitySelectItem { Id = s.Id, Value = s.PracticeType }).OrderBy(o => o.Value); response = GetList <EntitySelectItem>(query, 0, 100); if (response.IsOk()) { response.CacheIt <EntityList <EntitySelectItem> >(CacheKeys.PracticeTypes); } } catch (Exception ex) { ex.Log(); } finally { base.DBClose(); } return(response); }