Performance related to LINQ [Resolved]

Posted by Amatya under C# on 2/12/2016 | Points: 10 | Views : 96 | 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


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


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

Thanks & Regards,
RNA Team

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response