Summarize the comparison of LINQ and SQL syntax

Not comparable. LINQ is mainly used in programming languages, and SQL is mainly used in databases. As for the efficiency of querying SQL, it should be LINQ or SQL support.

LinQ to SQL is certainly not as efficient as traditional ones.

Although SQL seems to be metadata speech processing, but there is a transformation at the bottom, but the transformation of linq is more, the first transformation is to turn what you write, into SQL statements, which is no different from your own handwriting, but this transformation is resource-consuming, of course, it can be ignored, the grammar is a bit object-oriented, but the operation is inconvenient, it is better to directly use metaSQL statements to operate, and there is no need for linq to convert.

LinQ to SQL is certainly not as efficient as the traditional one, but the framework is certainly not as efficient as the direct one, because the LinQ statement is compiled into T-SQL by the compiler, and then passed to the database for execution.

But why do we even use frameworks? Because of convenience, the framework makes it easy for us to program. LinQ to SQL simplifies our class, with 30 lines to encapsulate data into a class, we may only need one line of LINQ SQL.

LINQ is object-oriented SQL. In other words, SQL is a query to a relational database, while LINQ is actually a query to data in memory.

Although LINQ was originally an object query, through the efforts of MS, it is possible to analyze the mapping to entity to relationship (LINQ) through the expression answer dust

tosql), convert LINQ to SQL statements or query XML (LINQ

toxml)。

Therefore, this technology has become a convenient tool for mapping, transformation and operation of object-to-database records, you no longer have to use string concatenation to generate SQL according to different situations, but concentrate on the processing of the object model, and your modifications to the object will eventually be converted into the corresponding SQL statements such as update, insert, delete, etc., and all of them will be submitted to the database when you submit.

In short, linq

ToSQL is an intermediate layer of database-to-object structure, which transforms the management of relational data into an object-specific operation, which can be used to avoid the troublesome SQL, and can also be helped by the powerful IntelliSense function.