在C#中使用lambda进行内连接

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

class Program
{
    static void Main()
    {
        // 创建两个示例表
        List<Student> students = new List<Student>()
        {
            new Student { Id = 1, Name = "Alice", Age = 20 },
            new Student { Id = 2, Name = "Bob", Age = 21 },
            new Student { Id = 3, Name = "Charlie", Age = 22 }
        };

        List<Course> courses = new List<Course>()
        {
            new Course { Id = 1, Name = "Math" },
            new Course { Id = 2, Name = "Science" },
            new Course { Id = 3, Name = "English" }
        };

        // 使用lambda进行内连接
        var result = students.Join(courses, student => student.Id, course => course.Id, (student, course) => new
        {
            student.Name,
            course.Name
        });

        // 输出结果
        foreach (var item in result)
        {
            Console.WriteLine($"{item.Name} - {item.Name}");
        }
    }
}

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

class Course
{
    public int Id { get; set; }
    public string Name { get; set; }
}