Knowledge baseExam Center
ENEnglish
Choose language13

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`.

Sources