What’s the difference between LINQ to SQL and Entity Framework?

Technology Community › Category: Entity Framework › What’s the difference between LINQ to SQL and Entity Framework?

VietMX Staff asked 3 years ago

LINQ to SQL is good for rapid development with SQL Server. EF is for enterprise scenarios and works with SQL Server as well as other databases.
LINQ maps directly to tables. One LINQ entity class maps to one table. EF has a conceptual model and that conceptual model maps to the storage model via mappings. So one EF class can map to multiple tables, or one table can map to multiple classes.
LINQ is more targeted towards rapid development while EF is for enterprise level where the need is to develop a loosely coupled framework.