/// <summary> /// Load list of diseases in a speciality /// </summary> /// <param name="specialityId">Speciality ID</param> /// <returns>List[Disease] that contains a list of Diseases in a Speciality</returns> public static async Task <List <Disease> > LoadDiseaseInSpecialityAsync(int specialityId) { // Return list of diseases using (LinqDBDataContext data = new LinqDBDataContext()) { return(await Task.Run(() => (from d in data.SP_LOAD_DISEASE_IN_SPECIALITY(specialityId) select new Disease() { Disease_ID = d.Disease_ID, Disease_Name = d.Disease_Name }).ToList())); } }