linq 常用方法记录

1.join 表 多个联合条件写法

List<STUDENT_INFO> list =new List<STUDENT_INFO>();//学生班级信息表
 list= (from u in dbcontext.STUDENT.Where(u => u.SEX== "男")
        join m in dbcontext.SCHOOL_CLASS
        on 
        new { patientid = u.CLASS_NAME, visitid = u.CLASS_ID}
        equals 
        new { patientid = m.CLASS_NAME, visitid = m.CLASS_ID}
        select new 
        {
            ID= u.ID,
            NAME= m.NAME,
            CLASS_TYPE= m.CLASS_TYPE
        }
       ).ToList();