Entity Framework

  • Entity Framework used various Database(such as oracle,db2,sql server, mysql etc).
  • Entity Framework generate .edmx extension file.
  • It is support complex type.
  • Relationship tables/view one-to-one, one-to-many, many-to-many.
  • Three Difference way to using data Query.
  1. Entity SQL
  2. ObjectContext
  3. DbContext

Linq To SQL

  • Linq To SQL Used only one Sql Server Database.
  • It is generate .dbml extension file.
  • It is not support complex type.
  • Relationship Tables/view one-to-one.
  • It is use data query DataContext
  • It is provide tightly coupled approach.