Buy Questpond's video subscriptions on
huge discount
.
Online: 428
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
C#
>
Loading ...
Performance related to LINQ [Resolved]
Posted by
Amatya
under
C#
on 2/12/2016 |
Points: 10
| Views : 709 | Status :
[Member]
| Replies : 1
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
Good Morning guys.. Can i know with respect to performance LINQ is better or Stored Procedure? Here Iam talking about LINQ to SQL.
Feel free to share informations.
mail Id ' adityagupta200@gmail.com
Thanks
[Resolved]
Reply
|
Reply with Attachment
Alert Moderator
Responses
Posted by:
Rajnilari2015
on: 2/12/2016
[Member]
[Microsoft_MVP]
[MVP]
Platinum
|
Points: 50
0
I's LINQ and the below is a supportive statement for the same
Debugging
- It is really very hard to debug the Stored procedure but as LINQ is part of .NET which allows easy debugging.
Deployment
- 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.
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.
Built-in security
- LINQ to SQL already has parameterizes input, which is already secure and helps to prevent SQL injection.
For more information , please visit
https://social.msdn.microsoft.com/Forums/en-US/019228c5-1435-4833-94f7-32a9a8e2a417/what-is-the-advantage-of-linq-over-stored-procedures?forum=linqtosql
--
Thanks & Regards,
RNA Team
Amatya
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Login to post response
Latest Posts
Climax Delay Condoms for Long Lasting Pleasure
(0)
Iterating over columns of dataframe and print as rows in Python Django
(0)
Where can I found sample MVC projects to learn and improve skills
(1)
Extract a value from HTML string
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
Get only year part from date string in SQL server
(0)
More ...