使用LINQ从集合中选择具有其他集合中相关项的所有字段

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

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

public class Address
{
    public string City { get; set; }
    public string Country { get; set; }
    public string PersonName { get; set; }
}

public class Program
{
    public static void Main()
    {
        List<Person> people = new List<Person>()
        {
            new Person { Name = "John", Age = 25 },
            new Person { Name = "Mary", Age = 30 },
            new Person { Name = "David", Age = 35 }
        };

        List<Address> addresses = new List<Address>()
        {
            new Address { City = "New York", Country = "USA", PersonName = "John" },
            new Address { City = "London", Country = "UK", PersonName = "Mary" },
            new Address { City = "Paris", Country = "France", PersonName = "David" }
        };

        var query = from person in people
                    join address in addresses on person.Name equals address.PersonName
                    select new { person.Name, person.Age, address.City, address.Country };

        foreach (var result in query)
        {
            Console.WriteLine($"Name: {result.Name}, Age: {result.Age}, City: {result.City}, Country: {result.Country}");
        }
    }
}