Wednesday 21 December 2016

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
Posted by at

2 comments:

  1. rmouniak3 October 2018 at 00:37

    Very nice Thanks for sharing
    .Net Online Course

    ReplyDelete
  2. rohini19 February 2019 at 23:28

    It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.
    iphone display replacement | Water damage service | iphone glass replacement | Battery replacement | 100% genuine apple parts | iphone unlocking service

    ReplyDelete

Subscribe to: Post Comments (Atom)