Synopsis
- Introduction
- Syntax
- Advantages
- Types
- Operators
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
- It offers Syntax Highlighting to find out errors during Design time.
- Write queries easily
- Development time is reduced.
- Easy debugging
- Transformation of data from one to another easily like SQL to XML
Types of LINQ
- LINQ to objects
- LINQ to SQL(DLINQ)
- LINQ to dataset
- LINQ to XML(XLINQ)
- LINQ to entities
LINQ Query Operators
Query operators are identified based on their functionalities.
- Filtering Operators
- Join Operators
- Projection Operations
- Sorting Operators
- Grouping Operators
- Conversions
- Concatenation
- Aggregation
- Quantifier Operations
- Partition Operations
- Generation Operations
- Set Operations
- Equality
- Element Operators
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,
- Where
- ofType
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,
- join – join two matching key values
- GroupJoin – join key values and grouping that two matching values
Projection Operations
Project values show the values of particular specific keys.
The Operators used for Projection is,
- Select
- SelectMany
Manimekalai GanesanPosted Jun 7, 2016, 5:35 AM
thank you sonu
Sonu ChaudharyPosted May 26, 2016, 10:24 AM
good explanation
Bhuvanesh MohankumarPosted May 6, 2016, 3:52 PM
Good one...
Manimekalai GanesanPosted Apr 11, 2016, 3:07 AM
Thank you Gowtham sir
Gowtham RajamanickamPosted Apr 11, 2016, 2:58 AM
good one...
Manimekalai GanesanPosted Apr 4, 2016, 1:22 AM
Thank you Kuppurasu sir
Kuppurasu NagarajPosted Apr 3, 2016, 4:27 AM
Nice
Manimekalai GanesanPosted Apr 1, 2016, 7:40 AM
thank you Tapan
Ekrem TapanPosted Apr 1, 2016, 4:46 AM
thanks
Manimekalai GanesanPosted Apr 1, 2016, 1:22 AM
Thank you viki
Vignesh ManiPosted Mar 31, 2016, 8:53 AM
Nice one mani