Language Integrated Query, introduced in.NET Framework 3.5, queries data from collections, generics, XML documents, ADO.NET Datasets, SQL, Web Services, and more. 

Namespace: System.Linq 

Advantages of LINQ

•  LINQ provides uniform query syntax for multiple data sources with less effort.
• LINQ uses less code than ADO.NET, reducing code.
• Compile-time error checking and Visual Studio integration are fully supported by LINQ. This powerful feature prevents runtime mistakes.
• LINQ has many built-in methods for filtering, sorting, grouping, etc.

 

Negatives of LINQ

• Complex SQL queries are hard to write. Complex queries took longer to compile with LINQ.
• We cannot use SQL server's Cache Execution strategy.
• Recompiling and redeploying the program after query changes is required. The LINQ query and method syntaxIn LINQ, we can use query or method syntax. Append and Concat have no query syntax equivalents.