S.No | LINQ To SQL | Entity Framework |
1. | LINQ to SQL only works with SQL Server. | It works with various RDBMS like Oracle, MySQL, SQL Server, DB2 |
2 | LINQ to SQL cannot generate the database based on model classes. | Entity Framework generates the database based on model classes |
3 | LINQ to SQL uses the Data Context class to interact with a database. | Entity Framework generates the DBContext class to interact with the database. |
4 | LINQ to SQL is tightly coupled. | Entity Framework is Loosely Coupled |
5 | It supports only 1-1 relation while mapping the relational tables with classes. | It supports the 1-1, 1-*, *-1, *-* relation while mapping relation tables with classes |
6 | It does not support the complex type. | It supports the complex type |
7 | It will generate the DBML file (Database Mark up Language) and the file with 3 sections to represents the schema: csdl, msl,ssdl | It generates the .EDMX file (Entity Data Model Extension) |
8 | Very slow for the first query | Very slow for the first query. But overall performance is better than LINQ TO SQL |
9 | Rapid Development | Development time is slower than LINQ to SQL but it provides more capabilities |
10 | LINQ TO SQL works based on ORM Pattern | Entity Framework also works based on ORM Pattern |
I am providing latest Interview Questions with Answers. Candidate has prepared their interview and get job. Mobile: 8920128728
Thursday, September 12, 2019
Difference Between LINQ To SQL And Entity Framework
Subscribe to:
Post Comments (Atom)
Get max value for identity column without a table scan
You can use IDENT_CURRENT to look up the last identity value to be inserted, e.g. IDENT_CURRENT( 'MyTable' ) However, be caut...
-
Android Studio Flamingo | 2022.2.1 Build #AI-222.4459.24.2221.9862592, built on March 31, 2023 Gradle JDK: jbr-17 (JetBrains Runtime version...
-
What is SQL? SQL is a database language designed for the retrieval and management of data in a relational database. SQL is the standard lan...
-
1) Explain Django. Django is a free and open source web application framework, written in Python. It is a server-side web framework that...
No comments:
Post a Comment