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.
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.