What is the difference between the Entity Framework and LINQ to SQL?

    2 answers 2

    Linq2Sql allows you to use arbitrary types in the properties on which DB columns are promoted, for example, enumerations.

    Linq2Sql allows you to add generated code.

    Linq2Sql allows you to convert to the list of objects the result of an arbitrary query written in the form of sql text.

    EntityFramework allows data for a single class of business logic to be placed in several database tables.

    EntityFramework has an extensible data access interface that allows it to be used with different DBMS.

    • one
      The answer is somewhat outdated - Pavel Mayorov

    Entity Framework is the ORM for .net. LINQ to SQL is a library that allows you to work with sql subd using linq.

    LINQ itself is not limited to "New form write request". With it, you can work with any data provider - memory, xml, ...

    • 3
      LINQ to SQL is also ORM. But it supports only DBMS MS SQL Server and SQL Server CE. - Modus