Pros & Cons of Using LINQ

Pros

• Quick turn around for development 
• Queries can be dynamically 
• Tables are automatically created into class 
• Columns are automatically created into properties 
• Relationship are automatically appended to classes
• Lambda expressions are awesome Data is easy to setup and use 

Cons

• No clear outline for Tiers
•  No good way of view permissions 
• Small data sets will take longer to build the query than execute 
• There is an overhead for creating queries 
• When queries are moved from sql to application side, joins are very slow DBML concurrency issues 
• Hard to understand advance queries using Expressions