Skip to content
Tagged articles

LINQ

6 articles · Page 1 of 1
Feidie Network
Feidie Network
Oct 10, 2026 · Fundamentals

C# Deep Dive: Type System, Generics, Async & Compiler Internals

This article provides a comprehensive deep dive into C# internals, covering the type system (value vs reference types, boxing, string immutability), OOP pillars, generics with covariance/contravariance, delegates/events, lambda/LINQ deferred execution, async/await state machines and synchronization context, reflection performance, Span/Memory zero-allocation patterns, and source generators for compile-time metaprogramming.

Async/AwaitC++Generics
0 likes · 20 min read
C# Deep Dive: Type System, Generics, Async & Compiler Internals
Java Captain
Java Captain
Oct 6, 2026 · Backend Development

Java Stream API: LINQ-Style Collection Filtering & Extraction

This tutorial demonstrates Java Stream API for filtering and extracting collection data, covering stream creation from Lists, Sets, Maps, and arrays, key operations like filter, limit, skip, concat, distinct, and collecting results into List, Set, or Map with practical code examples.

JavaJava 8LINQ
0 likes · 13 min read
Java Stream API: LINQ-Style Collection Filtering & Extraction
Architecture Digest
Architecture Digest
Oct 11, 2020 · Databases

Understanding the Execution Order of SQL Queries

This article explains why SQL queries do not start with SELECT, outlines the typical logical execution order of clauses such as FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT, and discusses how database engines may reorder operations for optimization, with code examples and comparisons to LINQ and pandas.

LINQPandasSQL
0 likes · 6 min read
Understanding the Execution Order of SQL Queries
Java Backend Technology
Java Backend Technology
Jun 20, 2020 · Databases

What’s the Real Execution Order of SQL Queries? A Visual Guide

Although most SQL statements begin with SELECT, the actual execution follows a specific order—WHERE, GROUP BY, HAVING, then SELECT—illustrated by a diagram that also clarifies common misconceptions about filtering window functions, column aliases, and how databases may reorder operations for optimization.

LINQPandasSQL
0 likes · 6 min read
What’s the Real Execution Order of SQL Queries? A Visual Guide