Pros and cons of LINQ.

Last updated:9/23/2020 5:32:19 PM

1 Answers

Anonymous User
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.