Sunday, September 27, 2015

LINQ To SQL Vs. Entity Framework


Following are some comparison between LINQ to SQL and entity framework

CategoryLINQ to SQLEntity Framework
Model
domain model

conceptual data model
Databases Supportedas the name indicates: SQL server only
variety of databases

Data Sources

tables only

tables, replication, reporting Services, BI and etc
Complexitysimple to usecomplex to use
Development Timerapid developmentslower development but more capabilities
Mappingclass to single tableclass to multiple tables
Inheritancehard to applysimple to apply
File Typesdbml files onlyedmx files
after compilation generate 3 xml files to represent the schema:
csdl, msl and ssdl
There are more differences between the frameworks but these are the 
most important.

No comments: