LINQ stands for Language Integrated Query.
LINQ was introduce with .NET 3.5 and Visual Studio 2008.
You can use LINQ with C# and VB to query different types of data sources like SQL XML.
As LINQ name suggest, you can directly query data using C# language.
Advatange of using LINQ is that it data independent.
LINQ providea simple but very effective way to manipulate data from different data sources such as SQL Database, XML Documents.
Way to get data using LINQ:
1. LINQ to Object:
Query and Transform In-memory collections.
2. LINQ to SQL:
Seamlessly Query relational databases
3. LINQ to Entities:
Datamanipulation with Entity Framework.
4. LINQ to XML:
Simplyfying XML Document Querying and modification.
5. LINQ to Dataset:
Quering ADO.NET Dataset and Data Tables.