Group list data via linq-CSDN博客

本文链接：https://blog.csdn.net/soarheaven/article/details/5911764

本文通过一个具体的示例展示了如何使用C#和LINQ进行分组查询，并找到每个用户的最近更新记录。通过对一系列QuestionHistory对象的创建与操作，详细说明了如何获取每个用户的最后更新日期。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private static void QuestionSortTest()
        {
            List<QuestionHistory> qhl = new List<QuestionHistory>();
            qhl.Add(new QuestionHistory { User = "U1", UpdateDate = DateTime.Now.AddDays(-1) });
            qhl.Add(new QuestionHistory { User = "U1", UpdateDate = DateTime.Now.AddDays(2) });
            qhl.Add(new QuestionHistory { User = "U2", UpdateDate = DateTime.Now.AddDays(1) });
            qhl.Add(new QuestionHistory { User = "U2", UpdateDate = DateTime.Now.AddDays(-3) });
            qhl.Add(new QuestionHistory { User = "U3", UpdateDate = DateTime.Now.AddDays(4) });
            qhl.Add(new QuestionHistory { User = "U3", UpdateDate = DateTime.Now.AddDays(-5) });

            //Console.WriteLine(qhl.OrderByDescending(q => q.UpdateDate).ToList()[0].UpdateDate.ToString());
            var groupedResult =
                from q in qhl
                group q by new { User = q.User }
                    into mostChanges
                    select new
                    {
                        User = mostChanges.Key.User,
                        UpdateDate = mostChanges.Max(d=>d.UpdateDate)
                    };
            foreach (var q in groupedResult)
            {
                Console.WriteLine(q.User + ":" + q.UpdateDate.ToString());
            }
        }