C# Linq 集合作为查询条件获取数据

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication40
{
    public partial class _Default : Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            List<ClassDemo> classList = InitClass();
            List<StudentDemo> studentList = InitStudent();
            //Any  确定序列是否包含任何元素。获取班级1、班级2学生
            var myStudentList1 = studentList.
                Where(s => classList.Any(c => c.ClassID.Equals(s.ClassID)));
            //All   确定序列中的所有元素是否满足条件。获取班级1、班级2以外的学生
            var myStudentList2 = studentList.
                Where(s => classList.All(c => !c.ClassID.Equals(s.ClassID)));
        }
        private List<ClassDemo> InitClass()
        {
            List<ClassDemo> classList = new List<ClassDemo>();
            classList.Add(new ClassDemo { ClassID = 1, ClassName = "班级1" });
            classList.Add(new ClassDemo { ClassID = 2, ClassName = "班级2" });
            return classList;
        }
        private List<StudentDemo> InitStudent()
        {
            List<StudentDemo> studentList = new List<StudentDemo>();
            studentList.Add(new StudentDemo { StudentID = 1, StudentName = "学生1", ClassID = 1 });
            studentList.Add(new StudentDemo { StudentID = 2, StudentName = "学生2", ClassID = 1 });
            studentList.Add(new StudentDemo { StudentID = 3, StudentName = "学生3", ClassID = 2 });
            studentList.Add(new StudentDemo { StudentID = 4, StudentName = "学生4", ClassID = 3 });
            studentList.Add(new StudentDemo { StudentID = 5, StudentName = "学生5", ClassID = 4 });
            studentList.Add(new StudentDemo { StudentID = 6, StudentName = "学生6", ClassID = 4 });
            return studentList;
        }
    }
    class ClassDemo
    {
        public int ClassID { get; set; }
        public string ClassName { get; set; }
    }
    class StudentDemo
    {
        public int StudentID { get; set; }
        public string StudentName { get; set; }
        public int ClassID { get; set; }
    }
}