问查找带有检查的超级集的Linq查询

EN

class Program
{
    static void Main(string[] args)
    {
        
        List<Record> records = BuildTestData();
        List<Record> deduped = DeDupe(records);
        Console.Clear();

        foreach (Record r in deduped)
            Console.WriteLine($"Type:{r.Typ}, Text:{r.Txt}, ID:{r.ID} ");

        Console.ReadKey();
    }


    static List<Record> DeDupe(List<Record> dupes)
    {
        List<Record> excludes = new List<Record>();
        excludes.AddRange(dupes.GroupBy(x => new { x.Typ, x.Txt }).Where(y => y.Count() > 1).SelectMany(z => z.Where(a => string.IsNullOrEmpty(a.ID))));
        excludes.AddRange(dupes.Where(x => !excludes.Any(y => x == y) && dupes.Any(z => x != z && x.Txt != z.Txt && z.Txt.Contains(x.Txt))));
        return dupes.Where(x => !excludes.Any(y => x == y)).ToList();
    }


    static List<Record> BuildTestData()
    {
        return new List<Record>
        {
            new Record { Typ = "Name", Txt = "John", ID = null},
            new Record { Typ = "Name", Txt = "John", ID = "22"},
            new Record { Typ = "Name", Txt = "John Smith", ID = "2548"},
            new Record { Typ = "Hobby", Txt = "Singing", ID = null},
            new Record { Typ = "Hobby", Txt = "Dancing Singing", ID = null},
            new Record { Typ = "School", Txt = "XYZ", ID = null},
            new Record { Typ = "School", Txt = "XYZ", ID = "242"},
        };
    }
}

public class Record
{ 
    public string Typ { get; set; }
    public string Txt { get; set; }
    public string ID { get; set; }
}