public static async Task <List <Doctor> > LoadDoctorInDoctorHospitalAsync(int hospitalID) { List <SP_LOAD_DOCTOR_IN_DOCTOR_HOSPITALResult> result = null; List <Doctor> doctorList = new List <Doctor>(); Doctor doctor = null; using (LinqDBDataContext data = new LinqDBDataContext()) { result = await Task.Run(() => data.SP_LOAD_DOCTOR_IN_DOCTOR_HOSPITAL(hospitalID).ToList()); } foreach (SP_LOAD_DOCTOR_IN_DOCTOR_HOSPITALResult re in result) { doctor = new Doctor(); doctor.Doctor_ID = re.Doctor_ID; doctor.First_Name = re.First_Name; doctor.Last_Name = re.Last_Name; doctor.Degree = re.Degree; doctor.Experience = re.Experience; doctor.Photo_ID = re.Photo_ID; doctor.Working_Day = re.Working_Day; doctorList.Add(doctor); } return(doctorList); }