Performance related to LINQ [Resolved]

Posted by Amatya under C# on 2/12/2016 | Points: 10 | Views : 441 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

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

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

Latest Posts