Introducing LINQ
LINQ is a query execution pipeline used in the managed environment of .NET Framework. In essence, LINQ is Microsoft's object relational mapper between your business objects and the underlying data sources, and provides a simplified framework for accessing relational data in an object-oriented fashion.
LINQ can be used to map your business objects and the underlying data sources. These data sources can be databases, objects, collections of objects, or even XML document files. Note that both C# (from version 3.0 on) and VB.NET (from version 9 on) have support for LINQ.
LINQ is a part of the new versions of the C# and VB.NET compilers, and it comes with a powerful set of operators to ease the task of querying different data sources, such as SQL Server, XML, and so on. LINQ comprises a standard set of operators to facilitate query operations. We will learn more about LINQ query operators later in this chapter.
Why LINQ?
We often require querying data and display them in the presentation...