LINQ

Language Integrated Query — enables SQL-like query expressions or method chaining on collections, databases, XML, and more.

Syntax

csharp

// Query syntax:
var result = from x in collection where condition select x;
// Method syntax:
var result = collection.Where(x => condition).Select(x => x);

Example

csharp

var adults = users
  .Where(u => u.Age >= 18)
  .OrderBy(u => u.Name)
  .Select(u => new { u.Name, u.Email })
  .ToList();

var total = orders.Sum(o => o.Amount);
var grouped = products.GroupBy(p => p.Category);