LINQStudy Notes

Aggregate and Custom Accumulators

Learn how LINQ's Aggregate() operator implements a general-purpose fold, letting you build custom accumulation logic beyond Sum, Count, and Average.

Aggregate Functions: Sum, Count, Average

Learn how LINQ's Sum, Count, and Average operators collapse sequences into single scalar values, and how execution timing and edge cases affect their use.

Any, All, and Contains

Master LINQ's boolean-returning quantifier operators — Any, All, and Contains — and how their short-circuiting behavior makes them efficient existence checks.

Common LINQ Patterns

The recurring LINQ idioms — filtering, flattening, grouping, and joining — that show up in almost every C# codebase.

Custom LINQ Extension Methods

Learn how to write your own LINQ-style extension methods on IEnumerable<T>, including deferred execution with yield return and chaining conventions.

Debugging LINQ Queries

Practical techniques for stepping through, inspecting, and diagnosing bugs in LINQ query chains, including deferred execution pitfalls.

Deferred vs Immediate Execution

LINQ queries either execute immediately when defined or defer execution until enumerated — understanding which operators do which prevents subtle bugs and need…

Expression Trees Explained

Learn what expression trees are, how the compiler builds them from lambdas, and how providers like EF Core walk them to generate SQL.

Filtering with Where

Learn how LINQ's Where operator filters sequences using predicates, how deferred execution affects when the filter actually runs, and how to combine multiple c…

First, Single, and ElementAt

Understand the differences between First, Single, and ElementAt for extracting one element from a LINQ sequence, and how their exception behavior differs.

Grouping with GroupBy

Learn how LINQ's GroupBy operator clusters elements by a key into IGrouping sequences, including result selectors, composite keys, and how it differs from SQL'…

IQueryable vs IEnumerable

IEnumerable<T> executes LINQ queries in memory using compiled delegates, while IQueryable<T> builds expression trees that a provider like EF Core translates in…

Joining with Join

Learn how LINQ's Join operator performs inner joins between two sequences, how GroupJoin enables left-outer-join patterns, and how composite keys and performan…

Lambda Expressions in LINQ

Understand how lambda expressions power LINQ's filtering, projection, and aggregation operators, and how they differ from anonymous methods and expression tree…

LINQ Best Practices

Practical guidelines for writing readable, performant, and maintainable LINQ — from query composition to IQueryable pitfalls.

LINQ in Real Projects

How LINQ is actually used day-to-day in production .NET codebases, from EF Core queries to DTO projection and reporting.

LINQ Interview Questions

The conceptual questions, coding challenges, and gotchas that come up most often when LINQ is tested in C# interviews.

LINQ Performance Pitfalls

Learn the hidden costs of LINQ's declarative syntax, from multiple enumeration to deferred-execution surprises, and how to avoid them.

Query Syntax vs Method Syntax

LINQ offers two equivalent ways to write the same query — SQL-like query syntax and fluent, chainable method syntax — and knowing when to reach for each makes…

LINQ Quick Reference

A fast lookup of the core LINQ operators — filtering, projection, aggregation, and set operations — with syntax at a glance.

LINQ to Objects

LINQ to Objects is the flavor of LINQ that runs entirely in memory against IEnumerable<T> collections like arrays, List<T>, and Dictionary<T>, using compiled d…

LINQ to SQL and LINQ to Entities

Learn how LINQ to SQL and LINQ to Entities translate C# query expressions into database SQL, and how their architectures differ.

LINQ to XML

Learn to read, query, create, and modify XML documents in C# using the XDocument and XElement API combined with LINQ query syntax.

LINQ vs Loops

Compare LINQ's declarative query syntax against traditional for/foreach loops in terms of readability, composability, and raw performance.