子查询中c#链接到对象的自动增量

// 定义一个自动增量的对象类
class AutoIncrementObject
{
    public int Id { get; set; }
    public string Name { get; set; }
}

// 创建一个对象集合
List<AutoIncrementObject> objects = new List<AutoIncrementObject>
{
    new AutoIncrementObject { Id = 1, Name = "Object 1" },
    new AutoIncrementObject { Id = 2, Name = "Object 2" },
    new AutoIncrementObject { Id = 3, Name = "Object 3" }
};

// 创建另一个对象集合
List<AnotherObject> anotherObjects = new List<AnotherObject>
{
    new AnotherObject { Id = 1, Description = "Description 1" },
    new AnotherObject { Id = 2, Description = "Description 2" },
    new AnotherObject { Id = 3, Description = "Description 3" }
};

// 使用LINQ进行子查询和自动增量链接
var query = from obj in objects
            join anotherObj in anotherObjects on obj.Id equals anotherObj.Id
            select new
            {
                ObjectName = obj.Name,
                Description = anotherObj.Description
            };

// 遍历查询结果
foreach (var result in query)
{
    Console.WriteLine($"Object Name: {result.ObjectName}, Description: {result.Description}");
}