Entity Framework(EF) VS LINQ to SQL
Difference between Entity Framework and LinQ to SQL:
Entity Framework | LinQ to SQL |
It allows one-to-one, one-to-many & many-to-many mappings between the Entity classes and the relational tables /views | It allows only one to one mapping between the entity classes and the relational tables /views. |
It can works with various databases like Oracle, DB2, MYSQL, SQL Server etc. | It only works with SQL Server Database. |
It generates an .edmx files initially. The relation is maintained using 3 different files .csdl, .msl and .ssdl | It generates a .dbml to maintain the relation |
It has support for complex type. | It has not support for complex type. |
It can generate database from model. | It cannot generate database from model. |
It can be used for rapid application development with RDBMS like SQL Server, Oracle, DB2 and MySQL etc. | It can be used for rapid application development only with SQL Server. |
It provides a loosely coupled approach. Since its code first approach allow you to use Dependency Injection pattern which make it loosely coupled . | It provides a tightly coupled approach. |
It allows you to query data using EntitySQL, ObjectContext, DbContext. | It allows you to query data using DataContext. |
No comments: