LINQ & Stored Procedures
What is LINQ and how it is beneficial than Stored Procedures?

See All Responses Below...
Message Rating
Posted on: 23/05/2012
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.
Posted on: 29/05/2012
The concept of LINQ  offers a compact, expressive, and intelligible syntax for manipulatingdata. The real value of LINQ comes from its ability to apply the same query to an SQLdatabase, a DataSet, an array ofobjects in memory and to many other types of data as well. LINQ requires the presence of specificlanguage extensions.

 LINQ is more advantage than  stored procedures.

Debugging- Stored procedure hard  to debug but as LINQ is part of .NET, so we can use visual studio's debugger to debug the queries.
Type Safety- LINQ is checked  queries errors at compile time. It really good to programmer to encounter error when compiling rather than runt ime exception.

Deployment - With stored procedures, we need to provide an additional script for stored procedures but with LINQ everything gets complied into single DLL hence deployment becomes easy.
Share this page across other social networking sites

Please Login to Post Your Comments
Name (Max. 100 characters)
Please post your comments here
Select Language
Attach File(Max. Size: 2 MB)
A few simple rules when posting your Comments,
  1. Please post only answers relevant to the topic of discussion.
  2. Please dont misuse this site or do not be abusive, offensive, inappropriate,harass anyone on the boards or post ads or spam. Doing so will delete your inappropriate messages and will block or delete your account on this site. 

Related Threads

Group by in LINQ

Academic Projects