LINQ

LINQ (Language Integrated Query) is uniform query syntax in C# used to save and retrieve data from different sources. It is integrated in C#, thereby eliminating the mismatch between programming languages and databases, as well as providing a single querying interface for different types of data sources like an Object Collection, SQL server database, XML, web service etc.

LINQ always works with objects so you can use the same basic coding patterns to query and transform data in XML documents, SQL databases, ADO.NET Datasets , .NET collections, and any other format for which a LINQ provider is available.

LINQ standard query operators can be categorized into the following ones on the basis of their functionality.

• Filtering Operators (Where)
• Join Operators (Join)
• Projection Operations (Select)
• Sorting Operators (OrderBy , OrderByDescending)
• Grouping Operators (GroupBy)

Example:-

static void Main()
 {
 int[] arr = new int[5] { 11, 44, 22, 33, 55 };
 // var m = from n in arr select n;
// var m = from n in arr orderby n descending select n;
//var m = from n in arr orderby n ascending select n;
// var m = from n in arr where n < 44 select n;
var m = from n in arr orderby n where n > 22 select n;
 foreach (int a in m)
 {
 Console.Write(a+ "\t");
 }
 Console.ReadKey();
 }