What is LINQ and how to use it in C#

LINQ is a set of features introduced in .NET Framework 3.5 that allows us to perform functional compositions that work over iterables.

LINQ queries can be written in two interchangeable ways,

• Query syntax (query syntax)
• Method syntax (method syntax).

Both syntaxes are equivalent in functionality, and the choice between one or the other depends on the developer’s preferences and the context of use.

LINQ Syntax

LINQ can be used in two main ways in C#: with query syntax and with method syntax.

int[] numbers = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

var evenNumbers = numbers.Where(number => number % 2 == 0);

int[] numbers = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

var evenNumbers = from number in numbers
                  where number % 2 == 0
                  select number;

Common Operations in LINQ

Filtering

Filtering is done using the Where method.

var evenNumbers = numbers.Where(number => number % 2 == 0);

Projection

Projection transforms data into a new form. The Select method is used for this purpose.

var squares = numbers.Select(number => number * number);

Sorting

Sorting is achieved with the OrderBy and OrderByDescending methods.

var sortedAsc = numbers.OrderBy(number => number);
var sortedDesc = numbers.OrderByDescending(number => number);

Grouping

Grouping is done with the GroupBy method.

var grouped = numbers.GroupBy(number => number % 2 == 0 ? "Evens" : "Odds");

Aggregation

Aggregation summarizes the values of a collection using methods like Count, Sum, Average, Min, and Max.

int sum = numbers.Sum();
int count = numbers.Count();
double average = numbers.Average();
int min = numbers.Min();
int max = numbers.Max();

LINQ to Objects

LINQ to Objects allows querying in-memory collections like arrays and lists. This is the most common and basic way to use LINQ.

List<string> fruits = new List<string> { "Apple", "Banana", "Cherry", "Peach" };

var fruitsWithA = from fruit in fruits
                  where fruit.Contains("a")
                  select fruit;

foreach (var fruit in fruitsWithA)
{
    Console.WriteLine(fruit);
}

LINQ to XML

LINQ to XML allows for easy querying and manipulation of XML documents.

XDocument xmlDoc = XDocument.Load("fruits.xml");

var fruitsWithA = from fruit in xmlDoc.Descendants("fruit")
                  where fruit.Value.Contains("a")
                  select fruit;

foreach (var fruit in fruitsWithA)
{
    Console.WriteLine(fruit.Value);
}

LINQ to SQL

LINQ to SQL allows interaction with SQL Server databases using LINQ syntax.

DataContext db = new DataContext("connectionString");

var customers = from customer in db.GetTable<Customer>()
                where customer.City == "Madrid"
                select customer;

foreach (var customer in customers)
{
    Console.WriteLine(customer.Name);
}