CODEWITHSUNDEEP
linq-to-sqldata-access-layerado.net-entity-data-model
Rishabh Ohri
Rishabh Ohri

Reputation: 1310

ADO.NET Entity Framework and LINQ to SQL

Can anyone answer my question? We are deciding upon the implementation of our Data Access layer. Initially we were working with NHibernate but now there is a change, so please answer my question...

IS LINQ to SQL a part of the ADO.NET Entity framework or is it a separate library?

If I say I am using "LINQ to SQL" for my data access layer then does it mean I am using the ADO.NET Entity framework for implementing the data access layer.

Upvotes: 0

Views: 934

Answers (3)

Brian Mains
Brian Mains

Reputation: 50728

LINQ to SQL and ADO.NET Entity framework are two distinct products, and they implement two separate API's that do not match, meaning you can't just swap one out for the other. Both have their strengths and weaknesses depending on your viewpoints. .NET 4 will also add some improvements to both, more improvements slated to ADO.NET entity framework.

But they are different distinct ORM's, and you will have to choose one over the other...

Upvotes: 1

Michael Maddox
Michael Maddox

Reputation: 12489

IS LINQ to SQL a part of the ADO.NET Entity framework or is it a separate library?

No, it's a separate library.

If I say I am using "LINQ to SQL" for my data access layer then does it mean I am using the ADO.NET Entity framework for implementing the data access layer.

No. LinqToSql and Entity Framework are separate and competing products. Microsoft is recommending people use Entity Framework, yet the majority of people are using LinqToSql. Microsoft is pouring the large majority of its development resources into Entity Framework, not LinqToSql. In .NET 3.5, LinqToSql is generally a superior product to Entity Framework, but a direct comparison is difficult.

Upvotes: 1

Sharique
Sharique

Reputation: 4219

In short no , Linq to sql and Ado.net entity framework are 2 different things.

Linq is a language feature. Linq to Sql is an extention which allow you to use linq features with your db. It is like basic DAL generation tool. Ado.net entity framework is and ORM similar to NHibernate.

Upvotes: 0

Related Questions