如何在linq查询中嵌套对象？

// 假设有两个对象：Person 和 Address
public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int AddressId { get; set; }
}

public class Address
{
    public int Id { get; set; }
    public string Street { get; set; }
    public string City { get; set; }
}

// 创建一个示例数据集合
List<Person> people = new List<Person>
{
    new Person { Id = 1, Name = "John", AddressId = 1 },
    new Person { Id = 2, Name = "Jane", AddressId = 2 },
    new Person { Id = 3, Name = "Bob", AddressId = 1 }
};

List<Address> addresses = new List<Address>
{
    new Address { Id = 1, Street = "123 Main St", City = "New York" },
    new Address { Id = 2, Street = "456 Elm St", City = "Los Angeles" }
};

// 使用 LINQ 查询嵌套对象
var query = from person in people
            join address in addresses on person.AddressId equals address.Id
            select new
            {
                person.Name,
                person.Id,
                Address = new
                {
                    address.Street,
                    address.City
                }
            };

// 遍历查询结果
foreach (var result in query)
{
    Console.WriteLine($"Name: {result.Name}, Id: {result.Id}");
    Console.WriteLine($"Address: {result.Address.Street}, {result.Address.City}");
    Console.WriteLine();
}