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