Entity Framework Interview Question:

What are differences between Entity Framework and L2S?

Submitted by: Administrator

Entity framework has a full provider model. It supports not only SQL Server but also other database like Oracle, DB2, MySQL etc.

Most of the time L2S classes must be one-to-one with database objects e.g. Customer class can be mapped only with Customer table. Where as in Entity Framework you can map your domain class with multiple tables using various inheritance strategies like table per type (class) or table per hierarchy of classes etc.

You can have multiple modeling techniques using Entity Framework 4.1 like code first, model first or database first.

Microsoft has long term strategy to support and integrate Entity Framework with multiple Microsoft products.
Submitted by: Administrator