linq union合并子列表

Question

给定一个对象列表如下:

Instance
 - InstanceID

Version
 - VersionID
 - List<Instance> Instances

Activity
 - ActivityID 
 - List<Version> Versions

我想生成这样的列表:

Activity
 - ActivityID
 - List<Instance> Instances

目前停留在:

(from activity in activities
 select new {
            activity.ActivityID,
            VersionGroup = (from version in activity.Versions
                            group version by version.ActivityID into versionGroup
                            select versionGroup)
            })

只是不确定如何到达实例级别。

(from activity in activities
 select new { activity.ActivityID,
              Instances = activity.ActivityVersions.SelectMany(v => v.ActivityInstances).AsEnumerable() });

Answer 1

您可以使用 SelectMany展平子列表的方法:

var result = activities.Select(a => new
{
    a.ActivityId, 
    Instances = a.Versions.SelectMany(v => v.Instances)
                          .GroupBy(i => i.InstanceID)
                          .Select(grp => grp.First())
                          .ToList()
});

您可以将 GroupBy 逻辑替换为 Distinct自定义 IEqualityComparer<Instance> :

var result = activities.Select(a => new
{
    a.ActivityId, 
    Instances = a.Versions.SelectMany(v => v.Instances)
                          .Distinct(new InstanceComparer())
                          .ToList()
});

class InstanceComparer : IEqualityComparer<Instance>
{

    public bool Equals(Instance x, Instance y)
    {
        return x.InstanceID == y.InstanceID;
    }

    public int GetHashCode(Instance obj)
    {
        return obj.InstanceID.GetHashCode();
    }
}

我还没有做 null 检查，但它们很简单。当然，这是假设这是 LINQ to Object，因为没有其他标记。