LINQ in C#: Types of LINQ in C# with Example

Learn what LINQ is in C#, the different ways to write LINQ queries, and see examples of common LINQ operations.

What is LINQ?

LINQ, or Language Integrated Query, is a set of features that lets you write consistent, readable queries directly against collections, databases, XML, and more.

Query Syntax

Query syntax uses keywords like from, where, and select in a style similar to SQL, making it easy to read for those familiar with database queries.

Method Syntax

Method syntax uses extension methods like Where, Select, and OrderBy chained together with lambda expressions, offering a more compact, fluent style.

Common LINQ Operations

Typical LINQ operations include filtering with Where, projecting with Select, sorting with OrderBy, and aggregating with methods like Sum and Count.