LINQ to SQL or commonly called L2S was developed by the C# team of developers at the Microsoft, while EF was developed by the team that developed EF. The coupling in case of LINQ to SQL is very strong between the database schema and query classes, whereas in case of LINQ to EF, the coupling between underlying database and the querying classes is loose because you query database using Entity Data Model which introduces another layer abstraction between the database and querying classes. The major difference between LINQ to SQL & LINQ to EF is in the coupling between the database scheme and the classes that are used to query that database via LINQ. If you are not much familiar with foundations of LINQ, I would advise you to first have a look at my other tutorials on Getting Started with LINQ and Interpreted LINQ queries.īasically both LINQ to Entity Framework and LINQ to SQL are object-relational mappers on which LINQ queries can be executed. We will first start with our article by explaining how LINQ to SQL and then we will move towards LINQ to Entity framework. This article is not focused towards explaining ins and outs of entity framework this article explains that how LINQ can integrate with entity framework to achieve the desired data access feature. However, there are still plenty of features where ADO.NET beats entity framework, but developers are now switching to Entity Framework owing to its strong decoupling and separation of concerns between the business and data access logic. Entity framework is Microsoft’s latest data access technology and is considered a replacement for ADO.NET.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |