Pros and cons of LINQ (Language-Integrated Query)

Difference between LINQ and Stored Procedures.

1. Stored procedures normally are faster as they have a predictable execution plan. Therefore, if a stored procedure is being executed for the second time, the database gets the cached execution plan to execute the stored procedure.
2. LINQ supports type safety against stored procedures.
3. LINQ supports abstraction which allows framework to add additional improvements like multi threading. It’s much simpler and easier to add this support through LINQ instead of stored procedures.
4. LINQ allows for debugging using .NET debugger, which is not possible in case of stored procedures.
5. LINQ supports multiple databases against stored procedures which need to be re-written for different databases.
6. Deploying LINQ based solution is much simpler than a set of stored procedures .
Disadvantages of LINQ over Stored Procedures
Disadvantages of LINQ over Stored Procedures - LINQ needs to process the complete query, which might have a performance impact in case of complex queries against stored procedures which only need serialize sproc-name and argument data over the network.......
Overview of VB 2008
Overview of VB 2008 - base class libraries, new functionality added in VB 2008, role of the common intermediate language, benefits of CIL, role of .NET Type Metadata......
VB.NET - Define Shared member of the class
VB.NET - Define Shared member of the class - It is member of the class which can be access without creating instance of the class.....
Post your comment