Language Integrated Query(LINQ)
is a native data querying platform.Using LINQ, the developer can query data in .NET supported languages. It provides a set of operators for querying any data
source like collections of objects, database, XML
files etc.
From performance point of view, there may not be a great
difference between LINQ and Stored procedures. If you need to execute a single statement query, it is better to use LINQ, as it reduces the coding
effort.