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...
-
In case of fibonacci series, next number is the sum of previous two numbers for example 0, 1, 1, 2, 3, 5, 8, 13, 21 etc. The first two num...
-
Question 1. What Is Ai? Answer : Artificial intelligence ("AI") can mean many things to many people. Much confusion ar...
No comments:
Post a Comment