Following are some comparison between LINQ to SQL and entity framework.
Category | LINQ to SQL | Entity Framework |
Model |
domain model
|
conceptual data model
|
Databases Supported | as the name indicates: SQL server only |
variety of databases
|
Data Sources
|
tables only
|
tables, replication, reporting Services, BI and etc
|
Complexity | simple to use | complex to use |
Development Time | rapid development | slower development but more capabilities |
Mapping | class to single table | class to multiple tables |
Inheritance | hard to apply | simple to apply |
File Types | dbml files only | edmx 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.
most important.
No comments:
Post a Comment