lin to sql 多表连接如果在where条件中加关联表的条件

Question

 //请各位大虾帮帮忙弄了我好多天了               DataContext con = new DataContext();                 Survey entity = null;//接收的实体对象                 DataLoadOptions dl = new DataLoadOptions();                    dl.LoadWith<Survey>(c => c.SurveyAnswers);//关联SurveyAnswers表                                con.LoadOptions = dl;                entity = (from su in con.Surveys                           //where中我想让SurveyAnswers表的id等于传过来的id                          where  su.ID == ID //&& SurveyAnswers.ID == AnswerID                          select su).SingleOrDefault();

Answer 1

在dbml文件里面就可以映射的啊，干什么那么麻烦呢