CKTIS / C#
descending: practical reference
descending: practical reference: descending selects decreasing key order in query orderby syntax.
Version: C# language and .NET 10 reference runtime
Syntax
descending /* grammar-specific form */descending selects decreasing key order in query orderby syntax.
Use it for explicit descending order and combine it with subsequent keys.
Comparison semantics depend on the provider and collation for text data.
null ordering can differ between LINQ-to-Objects and a database.
The complete program actually uses descending; its exact expected stdout is 1:6:A;3:4:C.
Examples
using System;
using System.Buffers;
using System.Collections.Concurrent;
using System.Collections.Frozen;
using System.Collections.Generic;
using System.Collections.Immutable;
using System.Diagnostics;
using System.Globalization;
using System.IO;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;
using System.Text;
using System.Text.Json;
using System.Text.Json.Nodes;
using System.Text.Json.Serialization;
using System.Text.RegularExpressions;
using System.Threading;
using System.Threading.Channels;
using System.Threading.Tasks;
using Number = System.Int32;
var left = new[] { (Id: 1, Value: 3), (Id: 2, Value: 1), (Id: 3, Value: 2) };
var right = new[] { (Id: 1, Name: "A"), (Id: 3, Name: "C") };
var query = from item in left
join label in right on item.Id equals label.Id into labels
from label in labels.DefaultIfEmpty()
let doubled = item.Value * 2
where doubled > 2
orderby item.Value descending, item.Id ascending
select new { item.Id, doubled, Name = label.Name ?? "-" };
Console.WriteLine(string.Join(";", query.Select(row => $"{row.Id}:{row.doubled}:{row.Name}")));
Result
1:6:A;3:4:C
The complete program actually uses `descending`; its exact expected stdout is `1:6:A;3:4:C`.