Benefits of choosing LINQ

One question arise that "Why LINQ query is used rather that normal SQL query ???"

So your solution are here as follow   :

LINQ is integrated into the C# and VB languages and it provides syntax highlighting and IntelliSense features and even you can debug your queries using the integrated debugger in Visual Studio.

Using LINQ it is possible to write code much faster than older queries and lets you save half of the time spent writing queries.

Using LINQ you can easily see the relationships among tables and it helps you compose your query that joins multiple tables.

Transformational features of LINQ make it easy to convert data of one type into a second type. For example, you can easily transform SQL data into XML data using LINQ.