Every new thing comes with some advantages and some disadvantages. Here is a quick list of LINQ from
Microsoft Social MSDN[
^]
Advantages
1. Quick turn around for development
2. Queries can be dynamically
3. Tables are automatically created into class
4. Columns are automatically created into properties
5. Relationship are automatically appeaded to classes
6. Lambda expressions are awesome
7. Data is easy to setup and use
Disadvantages
1. No clear outline for Tiers
2. No good way of view permissions
3. Small data sets will take longer to build the query than execute
4. There is an overhead for creating queries
5. When queries are moved from sql to application side, joins are very slow
DBML concurrency issues
6. Hard to understand advance queries using Expressions
Check out :
1.
http://techieideas.blogspot.com/2010/02/advantages-and-disadvantages-of-linq.html[
^]
2.
http://stackoverflow.com/questions/14530/linq-to-sql-vs-stored-procedures[
^]
3.
http://stackoverflow.com/questions/2259894/what-are-the-advantages-or-disadvantages-of-using-dbml-for-linq2sql-queries[
^]
Hope this helps.
All the best.