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
TII stands for? Ans. TII stands for Table of incomplete instructions.

Explain the characteristics and utilities available into java that makes it appropriate for developing e-commerce applications. Following are the characteristics and utilities

What are controls? How to use them? Give examples for control. Controls are objects that can be placed in a form. The dissimilar controls are available in the Tool Box. After

There should be 1 server thread and N client threads, where N is supplied by the user as a command line argument. The server opens a file called "all_requests.dat", the file has

What is a transaction? A transaction is dialog program that alter data objects in a consistent way.

The lrd_stmt function associates a character string (generally a SQL statement) with a cursor. This function sets a SQL statement to be processed.

Q. Show Network Topology in digital system? This deals with the geometrical arrangement of nodes (endpoints consisting of physical devices such as terminals, printers, PCs, and

Discuss the basic structure and principle of operation of Time Slot Interchange (TSI) switch with the help of a neat diagram. Principle of time slot interchange  Time

Why is packet switching important? Give at least two reasons. Packet switching is significant due to the following two purposes: 1. A sender and the receiver require coordin

If various load generators need to access the similar physical files, rather than having to remember to copy the files every time they change, each load generator can reference a c