C# ling to sql 左表连接再内连接

 

 

  var list = (from a in _XXReadContext.taba
                                          join b in _XXReadContext.tabb on a.id equals b.resume_id into a_left
                                          from left_a in a_left.DefaultIfEmpty()
                                          join c in _XXReadContext.tabc on left_a.skill_id equals c.id

                                          where a.id==id
                                          select new ResumeResponse
                                          {
                                             
                                              Tname= c.Tname

                                          }).Distinct().ToList();

　　注意：  左连接、内连接，一定是左表的字段放在equals左边，或先查的表，放在左边