LINQ - IQueryable多个where条件

using System;
using System.Linq;

class Program
{
    static void Main()
    {
        // 假设有一个表示学生信息的数据源
        IQueryable<Student> students = GetStudents();

        // 构建查询表达式，筛选出年龄大于18且成绩大于80的学生
        IQueryable<Student> query = students.Where(s => s.Age > 18 && s.Score > 80);

        // 执行查询
        foreach (var student in query)
        {
            Console.WriteLine($"{student.Name} - Age: {student.Age}, Score: {student.Score}");
        }
    }

    // 模拟获取学生信息的方法
    static IQueryable<Student> GetStudents()
    {
        // 假设这里返回一个包含学生信息的数据源
        return new Student[]
        {
            new Student { Name = "Alice", Age = 20, Score = 90 },
            new Student { Name = "Bob", Age = 19, Score = 85 },
            new Student { Name = "Charlie", Age = 18, Score = 75 },
            new Student { Name = "David", Age = 21, Score = 95 }
        }.AsQueryable();
    }
}

class Student
{
    public string Name { get; set; }
    public int Age { get; set; }
    public int Score { get; set; }
}