C# IQueryable .Union 重置排序

huangapple
go评论105阅读模式
英文:

C# IQueryable .Union reset sorting

问题

但是在 .Union 操作之后，排序被重置了。
如何防止排序被重置？

英文:

I have the following code:

  1. var expressions = new List<IQueryable<Container>>();
  3. var containers1 = containers
  4.     .Where(x => EF.Functions.Like(x.ContainerReference1, $"%{message.SearchValue}%")
  5.              || EF.Functions.Like(x.ContainerReference2, $"%{message.SearchValue}%"))
  6.     .OrderBy(x => x.ContainerReference1)
  7.     .ThenBy(x => x.ContainerReference2)
  8.     .ThenByDescending(x => x.DateUpdated);
  9. expressions.Add(containers1);
  11. var containers2 = containers
  12.                   .Where(x => EF.Functions.Like(x.Description, $"%{message.SearchValue}%"))
  13.                   .OrderBy(x => x.Description)
  14.                   .ThenByDescending(x => x.DateUpdated);
  15. expressions.Add(containers2);
  17. var containers3 = containers.Where(x => x.ContactEmails
  18.                             .OrderBy(y => y.Email)
  19.                             .ThenBy(y => y.DisplayName)
  20.                             .Any(y => EF.Functions.Like(y.Email, $"%{message.SearchValue}%")
  21.                                  || EF.Functions.Like(y.DisplayName, $"%{message.SearchValue}%")))
  22.                             .OrderByDescending(x => x.DateUpdated);
  23. expressions.Add(containers3);
  25. var containers4 = containers
  26.                             .Where(x => EF.Functions.Like(x.Keywords, $"%{message.SearchValue}%"))
  27.                             .OrderBy(x => x.Keywords)
  28.                             .ThenByDescending(x => x.DateUpdated);
  29. expressions.Add(containers4);
  31. containers = expressions.Aggregate((acc, i) => acc.Union(i));

But after .Union operation sorting is reset.
How can I prevent resetting of sorting?

答案1

得分: 1

Union 操作符不会保留元素的顺序。您需要根据数据的存在动态构建排序逻辑。

  1. var expressions = new List<IQueryable<Container>>();
  2. var sortingExpressions = new List<Func<IQueryable<Container>, IOrderedQueryable<Container>>>();
  4. var containers1 = containers
  5.     .Where(x => EF.Functions.Like(x.ContainerReference1, $"%{message.SearchValue}%")
  6.                 || EF.Functions.Like(x.ContainerReference2, $"%{message.SearchValue}%"));
  7. if (containers1.Any())
  8. {
  9.     var containers1Sorting = new Func<IQueryable<Container>, IOrderedQueryable<Container>>(x => x
  10.         .OrderBy(y => y.ContainerReference1)
  11.         .ThenBy(y => y.ContainerReference2)
  12.         .ThenByDescending(y => y.DateUpdated));
  14.     expressions.Add(containers1);
  15.     sortingExpressions.Add(containers1Sorting);
  16. }
  18. var containers2 = containers
  19.     .Where(x => EF.Functions.Like(x.Description, $"%{message.SearchValue}%"));
  20. if (containers2.Any())
  21. {
  22.     var containers2Sorting = new Func<IQueryable<Container>, IOrderedQueryable<Container>>(x => x
  23.         .OrderBy(y => y.Description)
  24.         .ThenByDescending(y => y.DateUpdated));
  26.     expressions.Add(containers2);
  27.     sortingExpressions.Add(containers2Sorting);
  28. }
  30. var containers3 = containers
  31.     .Where(x => x.ContactEmails
  32.         .Any(y => EF.Functions.Like(y.Email, $"%{message.SearchValue}%")
  33.             || EF.Functions.Like(y.DisplayName, $"%{message.SearchValue}%")));
  34. if (containers3.Any())
  35. {
  36.     var containers3Sorting = new Func<IQueryable<Container>, IOrderedQueryable<Container>>(x => x
  37.         .OrderBy(y => y.ContactEmails.OrderBy(z => z.Email).ThenBy(z => z.DisplayName))
  38.         .OrderByDescending(x => x.DateUpdated));
  40.     expressions.Add(containers3);
  41.     sortingExpressions.Add(containers3Sorting);
  42. }
  44. var containers4 = containers
  45.     .Where(x => EF.Functions.Like(x.Keywords, $"%{message.SearchValue}%"));
  46. if (containers4.Any())
  47. {
  48.     var containers4Sorting = new Func<IQueryable<Container>, IOrderedQueryable<Container>>(x => x
  49.         .OrderBy(y => y.Keywords)
  50.         .ThenByDescending(y => y.DateUpdated));
  52.     expressions.Add(containers4);
  53.     sortingExpressions.Add(containers4Sorting);
  54. }
  56. var mergedContainers = expressions.Aggregate((acc, i) => acc.Union(i));
  58. if (sortingExpressions.Any())
  59. {
  60.     var mergedSorting = sortingExpressions
  61.         .Aggregate((acc, next) => q => next(acc(q)));
  63.     containers = mergedSorting(mergedContainers);
  64. }
  65. else
  66. {
  67.     containers = mergedContainers.OrderByDescending(x => x.DateUpdated);
  68. }
英文:

Union operator does not preserve the order of the elements. You need to dynamically construct the sorting logic based on the presence of data

  1. var expressions = new List&lt;IQueryable&lt;Container&gt;&gt;();
  2. var sortingExpressions = new List&lt;Func&lt;IQueryable&lt;Container&gt;, IOrderedQueryable&lt;Container&gt;&gt;&gt;();
  4. var containers1 = containers
  5.         .Where(x =&gt; EF.Functions.Like(x.ContainerReference1, $&quot;%{message.SearchValue}%&quot;)
  6.                 || EF.Functions.Like(x.ContainerReference2, $&quot;%{message.SearchValue}%&quot;));
  7. if (containers1.Any())
  8. {
  9.     var containers1Sorting = new Func&lt;IQueryable&lt;Container&gt;, IOrderedQueryable&lt;Container&gt;&gt;(x =&gt; x
  10.         .OrderBy(y =&gt; y.ContainerReference1)
  11.         .ThenBy(y =&gt; y.ContainerReference2)
  12.         .ThenByDescending(y =&gt; y.DateUpdated));
  14.     expressions.Add(containers1);
  15.     sortingExpressions.Add(containers1Sorting);
  16. }
  18. var containers2 = containers
  19.           .Where(x =&gt; EF.Functions.Like(x.Description, $&quot;%{message.SearchValue}%&quot;));
  20. if (containers2.Any())
  21. {
  22.     var containers2Sorting = new Func&lt;IQueryable&lt;Container&gt;, IOrderedQueryable&lt;Container&gt;&gt;(x =&gt; x
  23.         .OrderBy(y =&gt; y.Description)
  24.         .ThenByDescending(y =&gt; y.DateUpdated));
  26.     expressions.Add(containers2);
  27.     sortingExpressions.Add(containers2Sorting);
  28. }
  30. var containers3 = containers
  31.         .Where(x =&gt; x.ContactEmails
  32.             .Any(y =&gt; EF.Functions.Like(y.Email, $&quot;%{message.SearchValue}%&quot;)
  33.                 || EF.Functions.Like(y.DisplayName, $&quot;%{message.SearchValue}%&quot;)));
  34. if (containers3.Any())
  35. {
  36.     var containers3Sorting = new Func&lt;IQueryable&lt;Container&gt;, IOrderedQueryable&lt;Container&gt;&gt;(x =&gt; x
  37.         .OrderBy(y =&gt; y.ContactEmails.OrderBy(z =&gt; z.Email).ThenBy(z =&gt; z.DisplayName))
  38.         .OrderByDescending(x =&gt; x.DateUpdated));
  40.     expressions.Add(containers3);
  41.     sortingExpressions.Add(containers3Sorting);
  42. }
  44. var containers4 = containers
  45.       .Where(x =&gt; EF.Functions.Like(x.Keywords, $&quot;%{message.SearchValue}%&quot;));
  46. if (containers4.Any())
  47. {
  48.     var containers4Sorting = new Func&lt;IQueryable&lt;Container&gt;, IOrderedQueryable&lt;Container&gt;&gt;(x =&gt; x
  49.         .OrderBy(y =&gt; y.Keywords)
  50.         .ThenByDescending(y =&gt; y.DateUpdated));
  52.     expressions.Add(containers4);
  53.     sortingExpressions.Add(containers4Sorting);
  54. }
  56. var mergedContainers = expressions.Aggregate((acc, i) =&gt; acc.Union(i));
  58. if (sortingExpressions.Any())
  59. {
  60.     var mergedSorting = sortingExpressions
  61.         .Aggregate((acc, next) =&gt; q =&gt; next(acc(q)));
  63.     containers = mergedSorting(mergedContainers);
  64. }
  65. else
  66. {
  67.     containers = mergedContainers.OrderByDescending(x =&gt; x.DateUpdated);
  68. }

huangapple
  • 本文由 发表于 2023年6月1日 19:40:19
  • 转载请务必保留本文链接：https://go.coder-hub.com/76381485.html
  • c#
  • iqueryable
  • linq
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定