Home / DeveloperSection / Interviews / Pros and cons of LINQ.
You haven’t finished your post yet. Are you sure you want to leave and discard your draft?
Can you answer this question?
Anonymous User
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:
- It 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.
You have need login or register for voting of answers or question.
Anonymous User
11-Apr-2018Pros 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:
- It 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.