LINQTOSQL vs EF5

Summary of differences/ similarity between LINQTOSQL vs EF5:

Entity Framework 5 LINQ TO SQL Difference/ Similar
Good for scenario where you expect 1-1, 1-N, M-N relationships between entity classes and relational tables/ views Good where only 1-1 mapping between the entity classes and the relational tables /views is expected. D
EF support multiple databases like MySQL, Oracle, apart from SQL It supports only one database D
Based on Generic Repository and Unit of work patterns Based on Generic Repository and Unit of work patterns S
Suitable for enterprise development Suitable for Rapid Application development D
Support Complex datatype Does not support Complex types D
Next version is available MS stops new versions D
Supports all 3 mapping approaches TPH, TPT, TPCT Supports only TPH D
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s