First, what is LINQ
Linq:language Integrated Query, the essence of which is to convert the ADO result set into an object set by reflection, along with the generic attribute, to realize the transformation of the or model.
Second, advantages and disadvantages
Pros: Encapsulate SQL statements, manipulate objects only, reduce code volume
Disadvantage: The pursuit of efficiency at the same time sacrificing performance, compared to the ADO performance is slightly worse, and the copy of the SQL statement is not good operation
Third, support those inquiries
Union, Group, sort, join query
Iv. what is LINQ to SQL
LINQ to SQL is part of LINQ, Full-dotnet language-integrated queries based on relational databases that manage relational data as objects and provide rich query functionality. It is a powerful LINQ with LINQ to XML, LINQ to Objects, LINQ to DataSet, LINQ to Entities.
V. Tools involved in learning
LINQPad 5,vs2015 (mainly learning several interfaces)
LINQ Learning (i)-Initial LINQ