Baza znanjaIzpitno središče
SLSlovenščina
Izberi jezik13

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

Viri