Synopsis
Introduction about LINQ
LINQ Stands for Language Integrated query which is used to access memory objects, Databases and XML documents and so on.
LINQ is designed by Anders Hejlsberg and it is introduced by Visual Studio 2008.
Syntax
Lambda Expression
Var Val = value. Where (Val<=5);
Query Syntax
Var Val = from val in Value Where val> 10;
Advantages
Types of LINQ
LINQ Query Operators
Query operators are identified based on their functionalities.
Let us discuss these operators in detail.
Filtering Operators
Used to select (or) filter particular object based on the condition.
The Operators used for filter is,
Join Operators
Based on the query condition the Join operators are used to join the row or column of the particular tables.
The Operators used for Join is,
Projection Operations
Project values show the values of particular specific keys.
The Operators used for Projection is,
Sorting Operators
It allows us to arrange the elements based on the sequence
The Operators used for Sorting are,
Grouping Operators
It is used to group the values based on a common attribute.
The Operators used for Grouping are,
Conversions
It is used to change the type of the Input.
The Operators used for Conversion are,
Concatenation
It is used to unite two values.
The Operators used for Concatenation are,
Aggregation
It is used to Aggregate (or) grouping (or) or for retrieving the sum of values.
The Operators used for Aggregation is,
Quantifier Operations
This is used to return Boolean Values that are True or False.
The Operators used for Quantifier are,
Partition Operators
It is used to divide the input sections into two separate sequences and return them.
The Operators used for Partition are,
Generation Operations
New sequence values created.
The Operators used for Generation are,
Set Operations
Getting the result based on the criteria.
The Operators used for Set Operation are,
Equality
It is used to compare two values and find whether those values are an exact match or not.
The Operators used for Equality are,
Element Operators
The Operators used for Element are,
We will discuss the types of LINQ in my next article. Thanks.
Read more articles on LINQ: