public IEnumerable <DiagnosisDTO> GetBydia_patient(string dia_patient) { using (MyContext ctx = new MyContext()) { var diags = ctx.Diagnosises.AsNoTracking().Where(e => e.dia_patient == dia_patient); List <DiagnosisDTO> list = new List <DiagnosisDTO>(); foreach (var s in diags) { DiagnosisDTO dia = new DiagnosisDTO(); // dia.doc_ID = s.doc_ID; // dia.dia_patient = s.dia_patient; dia.date = s.date.ToString(); dia.med_Num = s.med_Num; dia.med_ID = s.med_ID; dia.result = s.result; dia.visit_ID = s.visit_ID; //dia6.doc_ID = s.doc_ID; PatientService pa1 = new PatientService(); var dia1 = pa1.GetByID(dia_patient); foreach (var s1 in dia1) { dia.patient_name = s1.patient_name; } DoctorService pa12 = new DoctorService(); var dia2 = pa12.GetByID(s.doc_ID); foreach (var s2 in dia2) { dia.doctor_name = s2.doctor_name; } list.Add(dia); } return(list); } }