LINQ to SQL vs Entity Framework

Posted by Vishalneeraj-24503 under Entity Framework on 7/16/2017 | Points: 10 | Views : 2134 | Status : [Member] [MVP] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi All,

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts