orderbydescent在嵌套linq语句中不起作用

本文关键字:不起作用 语句 linq 嵌套 orderbydescent | 更新日期: 2023-09-27 18:03:23

在Linqpad中,我可以看到正确的列表。但在代码中,在放入列表集合后,order by对BeginDate不起作用。如果我使用BeginDate与Max,它的工作。我不明白我错在哪里?

            var templist =  contentRepository
                       .Get(q => (q.Status == (int)StatusEnum.Active) &&     
                           (q.CategoryId == category.GetHashCode() || q.Category.ParentId == category.GetHashCode())                   
                           && q.MinorVersion == 0
                           && q.MajorVersion > 0) 
                       .GroupBy(q => q.VersionId)
                       .OrderByDescending(q => q.Key)
                       .Select(q => new 
                       {
                           VersionId        = q.Key,
                           Id               = q.Max(x => x.Id),
                           MajorVersion     = q.Max(x => x.MajorVersion), 
                           UpdatedAt        = q.Max(x => x.UpdatedAt), 
                           //BeginDate        = q.Max(x=>x.BeginDate),
                           BeginDate        = (q.OrderByDescending(x => x.Id).Take(1).Select(x=>x.BeginDate)).First(),
                           Title = (q.OrderByDescending(x => x.Id).Take(1).Select(x => x.Title)).First(),
                           ShowOnHomePage   = (q.OrderByDescending(x => x.Id).Take(1).Select(x=>x.ShowOnHomePage)).First()
                        })
                       .OrderByDescending(x => x.BeginDate)                           
                       .Take(maxItemCount)
                       .ToList();
            List<ContentEntity> contents = new List<ContentEntity>();
        templist.ForEach(q => contents.Add(
                                         contentRepository
                                        .Get(x => x.VersionId == q.VersionId && x.MajorVersion == q.MajorVersion && x.MinorVersion == 0)
                                        .FirstOrDefault()                                        
                                        ));

        return contents.Where(q => q.ShowOnHomePage == true)
                       .OrderByDescending(q => q.MajorVersion)
                       .OrderByDescending(q => q.BeginDate)
                       .Take(maxItemCount)
                       .ToList();

orderbydescent在嵌套linq语句中不起作用

您是按Id排序,而不是按BeginDate排序。

的等效代码
q.Max(x => x.BeginDate)

将是

q.OrderByDescending(x => x.BeginDate).Take(1).Select(x => x.BeginDate).First()

或简化

q.OrderByDescending(x => x.BeginDate).First().BeginDate