| In order to operate, LINQ relies only on SQL Server DATABASES. | In order to operate, the entity framework relies on several databases including SQL Server, Oracle, MYSQL, DB2, etc. |
| It generates a .dbml to maintain the relationship. | In this case, an .edmx file is GENERATED first, then an .edmx file is maintained using three separate files- .csdl, .msl, and .ssdl. |
| DataContext enables you to query data. | ObjectContext, DbContext, and EntitySQL can all be used to query data. |
| Complex types are not supported. | Complex types are supported. |
| A database is not created from the model. | A database can be created from the model. |
| Application is developed more quickly using SQL Server. | Applications are developed more quickly using SQL Server and other databases like MYSQL, Oracle, DB2, etc. |
| It consists of a tightly COUPLED mechanism. | It consists of a loosely coupled mechanism. |
| Only one-to-one mappings are allowed. | One-to-one, one-to-many & many-to-many mappings are allowed. |
| It displays rapid development. | It takes longer to develop than LINQ, but it provides more CAPABILITIES. |
