Lorem ipsum dolor sit amet, consectetur adipiscing elit. Test link
Follow Me On Google News Follow Now!

Mention what is the difference between LINQ to SQL and Entity Framework?

                            LINQ to SQL                        Entity
  • It works only with SQL Server Database
  • To maintain the relation it generates a .dbml
  • It cannot generate database from model
  • It permits one to one mapping between the entity classes and relational views/tables
  • It enables you to query data using DataContext
  • It provides tightly coupled approach
  •  It works with various database like DB2, MYSQL, SQL Server etc.
  • It creates an .edmx files initially and relation is maintained using 3 different files .msl, .csdl and .ssdl
  • It can generate database from model
  • Between the entity classes and relational tables, it permits one-to-one, one-to-many and many-to-many
  • It enables you to query data using EntitySQL, DBContext, and ObjectContext
  • It provides loosely coupled approach

Post a Comment