Performance related to LINQ [Resolved]

Posted by Amatya under C# on 2/12/2016 | Points: 10 | Views : 118 | Status : [Member] | Replies : 1
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 9731764134
Thanks



Responses

Posted by: Rajnilari2015 on: 2/12/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
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