CKTIS / C#
on: praktična referenca
on: praktična referenca: on v query join pred equals uvede par izrazov ključa.
Različica: C# language; verified against C# 14 reference
Sintaksa
on /* grammar-specific form */on v query join pred equals uvede par izrazov ključa.
Uporabite samo v sintaksi join za outer in inner ključ.
Zunaj konteksta query ni operator bool ali splošno rezervirana beseda.
Tipi ključev morajo biti združljivi, primerjavo pa določa provider.
Celoten program dejansko uporabi on; natančno pričakovani stdout je 1:6:A;3:4:C.
Primeri
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}")));
Rezultat
1:6:A;3:4:C
Celoten program dejansko uporabi `on`; natančno pričakovani stdout je `1:6:A;3:4:C`.