LINQ is a set of APIs that help us work with XML, objects, and databases more easily. LINQ has many providers, including the following, all of which are commonly used:
- LINQ to objects: LINQ to objects allows developers to query in-memory objects such as arrays, collections, generic types, and so on. It returns an IEnumerable and supports features such as sorting, filtering, grouping, ordering, and aggregate functions. Its functionality is defined in the System.Linq namespace.
- LINQ to XML: LINQ to XML, or XLINQ, allows developers to query or modify XML data sources. It's defined in the System.Xml.Linq namespace.
- LINQ to ADO.NET: LINQ to ADO.NET is not one but a group of technologies that allows developers to query or modify relational data sources such as the SQL Server, MySQL, or Oracle.
- LINQ to SQL: This is also known as DLINQ. DLINQ uses Object Relational...
