SQL TO LINQ Where In子句with Max

// 假设有一个名为students的数据表，包含id和score两列
List<Student> students = new List<Student>
{
    new Student { Id = 1, Score = 80 },
    new Student { Id = 2, Score = 90 },
    new Student { Id = 3, Score = 85 },
    new Student { Id = 4, Score = 95 },
    new Student { Id = 5, Score = 75 }
};

// 使用LINQ查询语法实现WHERE子句和IN子句
var query = from student in students
            where student.Score > 80 && new[] { 2, 4 }.Contains(student.Id)
            select student;

// 使用LINQ方法语法实现WHERE子句和IN子句
var query = students.Where(student => student.Score > 80 && new[] { 2, 4 }.Contains(student.Id));

// 使用LINQ方法语法实现WHERE子句、IN子句和MAX函数
var maxScore = students.Where(student => new[] { 2, 4 }.Contains(student.Id)).Max(student => student.Score);