LINQ is all about queries, whether they are queries returning a set of matching objects, a single object, or a subset of fields from an object or set of objects. In LINQ, this returned set of objects is called a sequence.
LINQ to Objects :
LINQ to Objects is the name given to the IEnumerable<T> API for the Standard Query Operators. It is LINQ to Objects that allows you to perform queries against arrays and in-memory data collections.
LINQ to XML :
LINQ to XML is the name given to the LINQ API dedicated to working with XML. This interface was previously known as XLinq in older prerelease of LINQ.
LINQ to DataSet :
LINQ to DataSet is the name given to the LINQ API for DataSets. Many developers have a lot of existing code relying on DataSets.
LINQ to SQL :
LINQ to SQL is the name given to the IQueryable<T> API that allows LINQ queries to work with Microsoft’s SQL Server database. This interface was previously known as DLinq in older prerelease of LINQ.
LINQ to Entities :
LINQ to Entities is an alternative LINQ API that is used to interface with a database. It decouples the entity object model from the physical database by injecting a logical mapping between the two.