var allDoctorsInArea = db.Doctors.Where(i=>i.AreaDoctors.Where(j=>j.AreaID==userInformations.AreaID).Count()>0 && i.Maps_Pos.Count()==0). .Select(i => new { i.DoctorID, i.DoctorName }) .ToList();
id doctorid areaid ect ... 1 1 200 // this in Maps_pos (don't get it) 2 1 205 // this in Maps_pos (dont get it) 3 1 203 // user has this area (203) but i need to get doctorid (1) in this area only because it's don't saved in "Maps_pos" 4 2 300 // this in Maps_pos ect .......
id doctorid IDFromAreaDoctor pos1 pos2 ect ... 1 1 1 // here 1 is the id of record in areadoctor table .. .. 2 1 2 // here 2 is the id of record in areadoctor table .. .. 3 2 4 .. .. ect .......
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)