在C#中使用LINQ从列表或DataSet过滤数据

using System;
using System.Collections.Generic;
using System.Linq;

public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

class Program
{
    static void Main()
    {
        List<Person> people = new List<Person>
        {
            new Person { Name = "Alice", Age = 30 },
            new Person { Name = "Bob", Age = 25 },
            new Person { Name = "Charlie", Age = 35 }
        };

        var filteredPeople = people.Where(p => p.Age > 30);

        foreach (var person in filteredPeople)
        {
            Console.WriteLine($"{person.Name} is {person.Age} years old.");
        }
    }
}

using System;
using System.Data;

class Program
{
    static void Main()
    {
        DataSet dataSet = new DataSet();
        DataTable table = new DataTable();
        table.Columns.Add("Name", typeof(string));
        table.Columns.Add("Age", typeof(int));

        table.Rows.Add("Alice", 30);
        table.Rows.Add("Bob", 25);
        table.Rows.Add("Charlie", 35);

        dataSet.Tables.Add(table);

        var query = from row in dataSet.Tables[0].AsEnumerable()
                    where row.Field<int>("Age") > 30
                    select row;

        foreach (var row in query)
        {
            Console.WriteLine($"{row["Name"]} is {row["Age"]} years old.");
        }
    }
}