Entity Framework vs LINQ-to-SQL:

You may think that what is the difference between Entity Framework and LINQ to SQL which does that same thing. There are some differences between Entity Framework and L2S.

• 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.