Pros and cons of LINQ (Language-Integrated Query)

Pros and cons of LINQ (Language-Integrated Query).

Pros of LINQ:

- Supports type safety
- Supports abstraction and hence allows developers to extend features such as multi threading.
- Easier to deploy
- Simpler and easier to learn
- Allows for debugging through .NET debugger.
- Support for multiple databases

Cons of LINQ:

- LINQ needs to process the complete query, which might have a performance impact in case of complex queries
- LINQ is generic, whereas stored procedures etc can take full advantage of database features.
- If there has been a change, the assembly needs to be recompiled and redeployed.
Can we use LINQ with databases other than SQL Server?
LINQ with databases other than SQL Server - LINQ supports Objects, XML, SQL, Datasets and entities. One can use LINQ with other databases through LINQ to Objects or LINQ to Datasets.....
What is Linq to SQL Deferred Loading?
What is Linq to SQL Deferred Loading?......
Write a Program using Skip and Take operators. How can it beneficial for bulky data accessing on page?
“skip” and “take” Operator used for Paging. Suppose we have Customer table of 100 records. To find 10 records by skipping the first 50 records from customer table-
Post your comment