A Brief Introduction To LINQ

Introduction to LINQ.LINQ query can be written in three ways, Query expression, Fluent Syntax, Mixed Syntax. LINQ allows you to query local data (e.g LINQ to Objects) as well as remote data (LINQ to SQL).

In this article, I will give a brief introduction to LINQ.
 
LINQ stands for Language Integrated Query. LINQ was introduced with .NET framework 3.5 and C# 3. LINQ belongs to System.Linq namespace. So, before writing LINQ query, we need to use that namespace. LINQ allows you to write structured and type safe queries. It allows you to query local data (e.g LINQ to Objects) as well as remote data (LINQ to SQL). You can query any data which implements IEnumerable<T> interface.
 
The basic building blocks of LINQ are sequences and elements. A sequence is an object that implements IEnumerable<T> interface and an element is each item in that sequence.
 
You can write a LINQ query in VB as well as C#. LINQ query can be written in three ways,
  1. Query expression
  2. Fluent Syntax
  3. Mixed Syntax
We will discuss all three syntaxes in the following example.
 

Query expression

 
Getting even number from given sequence using query syntax.
  1. int[] number = new int[] {1, 2, 3, 4, 5, 6, 7, 8, 9};
    var result = from n in number
                 where n % 2 == 0
                 select n
    foreach(int item in result) {
          Console.WriteLine(item);
    }
Output

Output
 

Fluent Syntax

 
Getting even number from given sequence using fluent expression. 
  1. int[] number = new int[] {1, 2, 3, 4, 5, 6, 7, 8, 9};
    var result = number.Where(x => x % 2 == 0);
    foreach(int item in result) {
    Console.WriteLine(item);
    }
Output

Output
 

Mixed Syntax

 
In mixed syntax type, you can use both query expression and fluent syntax in a single query. 
  1. string[] name = new string[] {  
  2.     "ram",  
  3.     "sanju",  
  4.     "raju",  
  5.     "rakesh"  
  6. };  
  7. var result = (from s in name where s.EndsWith("u") select s).OrderBy(x => x.ToUpper());  
  8. foreach(string item in result) {  
  9.     Console.WriteLine(item);  
  10. }   
Output

Output
 
If you don’t want to use extension method, then you can write your query in the following way too. 
  1. int[] number = new int[]{1,2,3,4,5,6,7,8,9 };  
  2. var result = Enumerable.Where(number, x => x % 2 == 0);  
  3. foreach(int item in result) {  
  4.     Console.WriteLine(item);  
  5. }   
Output

Note
 
In the above example, the number issequence and each item is an element.
 
In the above example, "where" is an operator, and LINQ has around 40 operators. They are called standard query operators. An operator takes sequence as input and returns output.
 
In LINQ query, the data flows from left to right. Let’s understand this using the below example.
 
Example. 
  1. string[] name = new string[] {  
  2.     "ram",  
  3.     "raju",  
  4.     "rakesh"  
  5. };  
  6. var result = name.Where(x => x.EndsWith("u")).Select(x => x.ToUpper());  
  7. foreach(string item in result) {  
  8.     Console.WriteLine(item);  
  9. }   
Output

Output
 
In this query, first the data is filtered (where), then result data is selected (select).
 
Compiler processes the query expression by translating it into fluent syntax. This means that anything that you can write in query syntax, you can also write in fluent syntax too.
 
Summary
 
In this article, we discussed the basics of LINQ and different ways of writing LINQ query.