publicstatic List<Student>GetAllStudent(StudentDetail model){using(var db=newManagementEntities()){
db.Configuration.ProxyCreationEnable =false;//SQL 语句var query=from a in db.****join b in db.**** on a.X equals b.y
where a.X==****selectnewStudentData(){.................}}return query;}
2.GetAllStudent()方法进行封装 封装成为一个接口 相当于 Controller层
public Result<List<StudentData>> Get(Model model){var list = StudentService.GetAllStudent(model)returnnewResult<List<StudentData>>(list);}
1.定义一个方法 GetAllStudent()用 相当于Service层public static List<Student> GetAllStudent(StudentDetail model){ using(var db=new ManagementEntities()){ db.Configuration.ProxyCreationEnable =false; //SQL 语句 var query= from a in db.**** join b in