LINQ to SQL vs Entity Framework

Posted by Vishalneeraj-24503 under Entity Framework on 7/16/2017 | Points: 10 | Views : 1218 | Status : [Member] [MVP] | Replies : 3
Hi All,

In what scenario LINQ to SQL is good and in what scenario Entity Framework is good?




Responses

Posted by: Sarahbishop on: 7/22/2017 [Member] Starter | Points: 25

Up
0
Down
LINQ to SQL
It only works with SQL Server Database.
It generates a .dbml to maintain the relation
It has not support for complex type.
It cannot generate database from model.
Entity Framework
It can works with various databases like Oracle, DB2, MYSQL, SQL Server etc.
It generates an .edmx files initially. The relation is maintained using 3 different files .csdl, .msl and .ssdl
It has support for complex type.
https://sites.google.com/site/19216811wiki/

Vishalneeraj-24503, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jahnvi on: 3/12/2019 [Member] Starter | Points: 25

Up
0
Down
Entity Framework :
It can works with various databases like Oracle, DB2, MYSQL, SQL Server etc.
It generates an .edmx files initially. The relation is maintained using 3 different files .csdl, .msl and .ssdl
It has support for complex type.
It can generate database from model.
It allows you to query data using EntitySQL, ObjectContext, DbContext.
It provides a loosely coupled approach. Since its code first approach allow you to use Dependency Injection pattern which make it loosely coupled .
It can be used for rapid application development with RDBMS like SQL Server, Oracle, DB2 and MySQL etc.

LINQ to SQL :
It only works with SQL Server Database.
It generates a .dbml to maintain the relation
It has not support for complex type.
It cannot generate database from model.
It allows you to query data using DataContext.
It can be used for rapid application development only with SQL Server.
It provides a tightly coupled approach.

Vishalneeraj-24503, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jahnvi on: 3/12/2019 [Member] Starter | Points: 25

Up
0
Down
Entity Framework
It can works with various databases like Oracle, DB2, MYSQL, SQL Server etc.
It generates an .edmx files initially. The relation is maintained using 3 different files .csdl, .msl and .ssdl
It has support for complex type.
It can generate database from model.
It allows you to query data using EntitySQL, ObjectContext, DbContext.
It provides a loosely coupled approach. Since its code first approach allow you to use Dependency Injection pattern which make it loosely coupled .
It can be used for rapid application development with RDBMS like SQL Server, Oracle, DB2 and MySQL etc.

LINQ to SQL
It only works with SQL Server Database.
It generates a .dbml to maintain the relation
It has not support for complex type.
It cannot generate database from model.
It allows you to query data using DataContext.
It can be used for rapid application development only with SQL Server.
It provides a tightly coupled approach.

<a>http://www.ifourtechnolab.com/</a>


Vishalneeraj-24503, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response