已知学生(Student)实体类的定义如下: public class Student{ [key] public string id {get;set;} //学号 public string sname {get;set;} //姓名 public string classid {get;set;} //所属班级编号 } 已知班级(Classes)实体类的定义如下: public class Classes{ [key] public string id {get;set;} //班级编号 public string cname {get;set;} //班级名称 } 在EF的上下文StuContext中有学生列表StudentList和班级列表ClassesList,以下哪个语句不能查找出”计算机01班”的学生信息:
A.
from s in StuContext.StudentList from c in StuContext.ClassList where (s.classid=c.id & c.cname="计算机01班”) select s;
B.
from s in StuContext.StudentList join c in StuContext.ClassList on s.classid equals c.id where (c.cname="计算机01班”) select s;
C.
from c in StuContext.ClassList join s in StuContext.StudentList on c.id equals s.classid where (c.cname="计算机01班”) select s;
D.
StuContext.StudentList.Where((s,c)=> s.classid=c.id & c.cname="计算机01班” ).Select(s)