Advantage of Linq?

Benefits of LINQ

• Because LINQ is integrated into the C# language, it provides syntax highlighting and IntelliSense. These features make it easy to write accurate queries and to discover mistakes at design time.
• Because LINQ queries are integrated into the C# language, it is possible for you to write code much faster than if you were writing oldstyle queries. In some cases, developers have seen their development time cut in half.
• The integration of queries into the C# language also makes it easy for you to step through your queries with the integrated debugger.
• The hierarchical feature of LINQ allows you to easily see the relationship between tables, thereby making it easy to quickly compose queries that join multiple tables.
• The unitive foundation of LINQ allows you to use a single LINQ syntax when querying multiple data sources. This allows you to get up to speed on new technologies much more quickly. If you know how to use LINQ to Objects, it is not hard to learn how to use LINQ to SQL, and it is relatively easy to master LINQ to XML.
• Because LINQ is extensible, you can use your knowledge of LINQ to make new types of data sources queriable.
• After creating or discovering a new LINQ provider, you can leverage your knowledge of LINQ to quickly understand how to write queries against these new data sources.
• Because LINQ is composable, you can easily join multiple data sources in a single query, or in a series of related queries.
• The composable feature of LINQ also makes it easy to break complex problems into a series of short, comprehensible queries that are easy to debug.
• The transformational features of LINQ make it easy to convert data of one type into a second type. For instance, you can easily transform SQL data into XML data using LINQ.
• Because LINQ is declarative, it usually allows you to write concise code that is easy to understand and maintain.
• The compiler and provider translate declarative code into the code that is actually executed. As a rule, LINQ knows more than the average developer about how to write highly optimized, efficient code. For instance, the provider might optimize or reduce nested queries.
• LINQ is a transparent process, not a black box. If you are concerned about how a particular query executes, you usually have a way to examine what is taking place and to introduce optimizations into your query.

and follow this link