Advantage and Disadvantage of LINQ

Advantages

1. Faster development
2. Unit of work pattern (context)
3. Auto-generated domain objects that are usable small projects
4. Lazy loading.
5. Learning to write linq queries/lambdas is a must learn for .NET developers.
6. Quick turn around for development
7. Queries can be dynamically
8. Tables are automatically created into class
9. Columns are automatically created into properties
10. Relationship are automatically appeaded to classes
11. Lambda expressions are awesome
12. Data is easy to setup and use
13. LINQ offers a common syntax for querying any type of data sources
14. LINQ expedites development time by catching errors at compile time and includes IntelliSense & Debugging support
15. LINQ expressions are Strongly Typed.

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
6. DBML concurrency issues
7. Hard to understand advance queries using Expressions

Difference between LINQ and Stored Procedure

• In this Artical differences existing between LINQ and Stored procedures. These differences are mentioned below.
• Stored procedures are much faster than a LINQ query as they follow an expected execution plan.
• It is easy to avoid run-time errors while executing a LINQ query than in comparison to a stored procedure as the former has Visual Studio’s Intelligense support as well as full-type checking during compile-time.
• LINQ allows debugging by making use of .NET debugger which is not in case of stored procedures. Easly debugg in linq
• LINQ offers support for multiple databases in contrast to stored procedures in SQL, where it is essential to re-write the code for diverse types of databases.
• Deployment of LINQ based solution is easy and simple in comparison to deployment of a set of stored procedures in SQL. Using linq query it is complex when use jin in query and performance is slow as compare store procedure in Sql

Difference between LINQ to SQL v/s Entity Framework

LINQ to SQL	Entity Framework
It is only works with SQL Server Database you can write query with sql.	It can works with various multiple databases like Oracle, DB2, MYSQL, SQL Server etc.
LINQ to SQL use then generates .dbml to maintain the relation.	It generates an .edmx files initially. The relation is maintained using 3 different files .csdl, .msl and .ssdl
LINQ to SQL it has not support for complex type.	Entity Framework has support for complex type.
LINQ to SQL allows only one to one mapping between the entity classes and the relational tables /views.	Entity Framework allows one-to-one, one-to-many & many-to-many mappings between the Entity classes and the relational tables /views
Linq to sql allows you to query data using DataContext.	Entity Framework allows you to query data using EntitySQL, ObjectContext, DbContext.
LINQ to SQL provides a tightly coupled approach.	Entity Framework provides a loosely coupled approach. Since its code first approach allow you to use Dependency Injection pattern which make it loosely coupled .
LINQ to SQL can be used for rapid application development only with SQL Server.	Entity Framework can be used for rapid application development with RDBMS like SQL Server, Oracle, DB2 and MySQL etc.
LINQ to SQL is a complex type and it reduce performance as compare to Entity Framework.	Entity Framework is fast and less complex as compare to LINQ to SQL.