Choosing between ADO.NET Entity Framework and LINQ to SQL

re: Choosing between ADO.NET Entity Framework and LINQ to SQL

chungld — Fri, 02 Mar 2012 09:57:48 GMT

thank you, this story is very useful for me!

re: Choosing between ADO.NET Entity Framework and LINQ to SQL

MikeGale — Mon, 31 May 2010 21:35:11 GMT

Thanks for that. The L2S vs L2EF debate is still live (2010-06-01). There's ongoing debate, including ease of use and the wisdom of the "canonical form" used to work with different data providers. A complex area and one size definitely doesn't fit everybody.

I put up an experimental online application that looks at the choice.

It helps work through your own thoughts, with notes, links and an email containing a suggestion graphic.

An introduction to it is at decisionz.wordpress.com/.../suggestions-for-linq-tool-to-use (has a link to the live page).

It guides your own work, doesn't provide a single recommendation.

Might be useful to people looking at the choice.

re: Choosing between ADO.NET Entity Framework and LINQ to SQL

Lead Internet — Wed, 21 Apr 2010 22:30:34 GMT

Thanks for the info. It will be nice once this space matures and we don't have to decide on so many different data access options. I've used ado.net, wrote my own custom data access classes, used .netTiers, and Linq to Sql. I'd like to stay ahead of the curve so I'm going to try out the ADO.NET Entity Framework in hopes that this will be around for a while.

re: Choosing between ADO.NET Entity Framework and LINQ to SQL

Latif OZTURK — Sat, 11 Jul 2009 17:47:23 GMT

Thank you for sharıng this information with us.

re: Choosing between ADO.NET Entity Framework and LINQ to SQL

Chris Lively — Tue, 12 May 2009 23:06:45 GMT

Your deduction about LINQ to SQL is wrong. Specifically:

"There has been another concern comes from dev community is that is LINQ to SQL going to retire? Answer to that is no. Microsoft will continue to support L2S and enhance based on customer feedback. Tim Mallalieu clearly have mentioned in his Post that Microsoft will heavily invest into EF and the most wanted features like POCO will be with .NET 4.0. "

I read his post and the answer to the question is Yes: LINQ to SQL is going away. It is being replaced by LINQ to Entities / EF. He even stated in that post that he wants to know what people use in L2S in order to make sure it is in L2E.

In short, there isn't a choice. Either skip the whole LINQ thing or embrace the entity framework.

re: Choosing between ADO.NET Entity Framework and LINQ to SQL

Janus007 — Sat, 14 Mar 2009 14:10:50 GMT

Well, that's your opinion. I agree with you in that the L2E has many nice features

"It simplifies the data access and allows me to create conceptual model required for my business."

-> So does L2S, the conceptual model can be simplified through the use of views.

Ø EF allows you to handle Many to Many relationship without extra join.

-> Too bad for L2S, but again... use views :)

Ø Map related tables into single entity to reduce code complexity.

-> Yup... they told me so, but it doesn't work succesfully.

Ø Strong inheritance supports for (Table per hierarchy, subclass and concrete type)

-> Yup, but then again... isn't that cluttering your layer?

Ø Consolidation for complex object is very easy.

-> Not sure what you mean?

You forgot to mention that if the relational model changes you've to tear down all your tables in the designer and built it up from scratch again - which is something that just works perfectly in L2S.

L2E performance is poor, not to mention the funny SQL-statements it sometimes produce.

I think that Microsoft should put a big effort into joining the C#-team (L2S) with the ADO.NET-team (L2E) and then maybe they could produce something useful, as time is now it's frustrating.

ADO.NET Entity Framework vs LINQ to SQL

Wriju's BLOG — Fri, 13 Mar 2009 17:12:15 GMT

I have been getting a continuous request on what we should be using? LINQ to SQL or ADO.NET Entity Framework?

re: Choosing between ADO.NET Entity Framework and LINQ to Entity

Pena — Sun, 08 Mar 2009 14:08:14 GMT

Or ECO V http://www.capableobjects.com/

Choosing between ADO.NET Entity Framework and LINQ to Entity - Wriju's Blog

DotNetShoutout — Sun, 08 Mar 2009 12:17:15 GMT

Thank you for submitting this cool story - Trackback from DotNetShoutout

Click & Solve » Choosing between ADO.NET Entity Framework and LINQ to Entity

Sun, 08 Mar 2009 06:35:58 GMT

PingBack from http://www.clickandsolve.com/?p=19339