LINQ和Entity Framework之间的比较

LINQ to SQL advantages over the Entity Framework:
➤➤ Easy to get started and query
Entity Framework advantages over LINQ to SQL:
➤➤ Enables you to build a conceptual model of the database rather than purely working with a 1:1 domain model of the database as objects (such as having one object mapped to multiple database tables, inheritance support, and defining complex properties).
➤➤ Able to generate a database from your entity model.
➤➤ Support for databases other than just SQL Server.
➤➤ Support for many-to-many relationships.
➤➤ Lazy loading and eager loading support.
➤➤ Synchronization to get database updates will not lose your customizations to your model.
➤➤ Will continue to evolve, whereas LINQ to SQL development will from now on be minimal.

相对于Entity Framework，LINQ比较容易学习。
相对于LINQ，Entity Framework具有以下的优点：
1）可以建立一个概念意义上的数据库对象，而不是一个简单的1对1数据库模型作为对象（比如说一个对象可以映射到数据库中的多个表，继承性，还有定义复杂的属性。）
2）可以通过实体模型生成对于的数据库
3）可以支持多类型的数据库
4）可以支持多多的关系
5）延迟和及时加载
6）
7）Entity Framework技术会继续发展，而LINQ的开发也就那样了！

Menu