Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
LINQ VS Stored Procedure
July 26, 2012
i am learning LINQ. So Please tell me ,Difference between LINQ and Stored Procedure ?
Syed Shakeer Hussain
Posted Date: July 28, 2012 Points: 20
: Suppose you have a data in a DataSet. If you want to do Some operations on a DatSet Without hitting the DataBase then you to use LINQ.
: StoredProcedures are used to execute Sql Statemetns.
There are couple of advantage of LINQ over stored procedures.
- It is really very hard to debug the Stored procedure but as LINQ is part of .NET, you can use visual studio's debugger to debug the queries.
- 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.
- 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!
For more information check the below link
Posted Date: July 29, 2012 Points: 20
Thank for your reply.It is very useful to me and learners.
Regards, Lakshmi Naraayanan.S
To post reply
Related Questions Related Questions
i got a problem on registration form using stored procedure and classes
How to get output value from stored procedure?
Table name as parameter in SQL Stored Procedure
get value from output parameter from stored procedure
How do I call a Stored Procedure with one associative array as Out put Parameter ?
How to find the Recently accessed stored Procedure?
Where will the text of the stored procedure gets stored?
What is Precompiled in terms of Stored Procedure in Sql Server?
Difference between Stored Procedure and function in Sql Server
Can we have a Stored Procedure and a table with a same name? if not why?
Latest Forum Questions From The Same Category
To Achieve draw wave form from speaker outputs.
How to display the text in the second ck editor with strikes while extracting from database
Mail is working but I want send two excel file to each different person
how to display child nodes with headers and keeping the child nodes in a table
In DataGrid I have Two Dropdownlist, One in Header template and Item Template
Display data directly from database table to PDF using stored procedures in asp.net C#
How to install and use Dev Express ?
Dialogbox Custom Control
Custom Control in Winforms
I just started learning c#.net console application
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend