LINQ Learning (i)-Initial LINQ

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