Friday 12 October 2012

How Linq is more benifacial than stored procedure?

Hi Friends , Here I have explained how linq is more benifacial than stored procedure.

There are three basic points that explain how linq is benifacial than stored procedure.
1.)  Debugging: It is very hard to debugg stored procedure but as we know linq is the part of .NET , so we can use debugger to debugg the linq query.
2.)Development: at the time of deployment , we use additional script for stored procedure but for Linq query it is complied into a single DLL hence deployment is easy.
3.)Type Safety: Linq is type safe , so queries error are type checked at complie time but in case of stored procedure error are checked at run time.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.