How linq is beneficial than stored procedures, Computer Engineering

There are couple of benefit of LINQ over stored procedures.

 

1. Debugging - It is really very difficult to debug the Stored procedure but as LINQ is part of .NET, you can use visual studio's debugger to debug the queries.

2. Deployment - With stored events, we require to provide an additional script for stored procedures but with LINQ everything gets complied into one DLL hence deployment becomes easy.

3. Type Safety - LINQ is type safe, so queries errors are type checked at compile time. It is really good to encounter an error when compiling rather than runtime exception!               

 

                 

 

Posted Date: 4/3/2013 2:02:25 AM | Location : United States







Related Discussions:- How linq is beneficial than stored procedures, Assignment Help, Ask Question on How linq is beneficial than stored procedures, Get Answer, Expert's Help, How linq is beneficial than stored procedures Discussions

Write discussion on How linq is beneficial than stored procedures
Your posts are moderated
Related Questions
explain network operating system and design issues?

Subtraction of 0011.1001 - 0001.1110 using 2's complement method Ans. Firstly 1's complement of 0001.1110 is 1110.0001 and 2's complement is 1110.0010. If a last carry

Explain Anonymous FTP. Use of a login password and name helps maintain file secure from unauthorized access. Though, sometimes these authorizations can also be inconvenient.

1) All squares containing a 1 must be grouped. 2) The largest possible groups must be formed. 3) Groups can overlap if this allows larger groups to be formed. 4) Groups mu

I want to know...if there is a program available in C code using data structure for online movie booking system

Computer Arithmetic Data is manipulated with the help of arithmetic instructions in digital computers. Data is manipulated to  produce the results  necessary  to  provide solut

Explain difference between Security and Protection? Protection mechanism: The subsequent mechanisms are commonly utilized for protecting files having programs and data. (a

What courses draught in a simple pendulum experiment


Before proceeding with its execution, each process must acquire all the resources it needs is called ? Ans. Hold and Wait is requires in each process should acquire all the res