Entity Framwork or LINQ for MVC ?

Question

5.00/5 (1 vote)

See more:

I would like to Learn Mvc. so i just Google basic Registration Form .i got Result More Related to Accessing Sql server Through Entity Framework and LINQ to Sql .so i got Confused which one is Best and Which is powerful .
what is the Difference Of Both ?

Guid me,
Thanks

Posted 2-Nov-14 4:19am

King Fisher

Updated 2-Nov-14 5:14am

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2014-11-02T05:22:00

Solution 1

Have a look at the reponses to these very similar posts

http://stackoverflow.com/questions/3293995/what-is-the-difference-between-entity-framework-and-linq-to-sql-by-net-4-0[^]

http://blogs.msdn.com/b/swiss_dpe_team/archive/2008/11/06/entity-framework-vs-linq-to-sql.aspx[^]

http://www.dofactory.com/topic/1077/when-to-use-linq-to-sql-versus-entity-framework.aspx[^]

Posted 2-Nov-14 5:22am

CHill60

Comments

Afzaal Ahmad Zeeshan 2-Nov-14 11:28am

Right, or the user can himself try to check for the comparison. Mostly the developers are tensed or depressed about the effieciency and the speed of the code. He might also be talking about the speed of the code execution. To test the better code (according to the speed of its execution) he can run each code 100 times and calculate their mean time of code execution. Check against both values, and the code with less value will win. :-)

CHill60 2-Nov-14 11:44am

I don't think it's implied that he was looking at performance ("powerful" != "performant"). The posts I supplied cover most of the differences - in particular the last one which discusses the future of LinqToSql

Santosh K. Tripathi 12-Mar-15 1:02am

i agree with chill60.
"powerful" != "performant"

Manas Bhardwaj 2-Nov-14 12:51pm

Yes +5!

Afzaal Ahmad Zeeshan · Answer 2 · 2014-11-02T05:27:00

This is a broad topic and you might want to Google the topic for some related articles or blog posts.

Here are a few posts. http://forums.asp.net/t/1700742.aspx?+Entity+framework+Versus+Linq+to+SQL+classes+[^]

Tabular form of difference, http://www.dotnet-tricks.com/Tutorial/entityframework/1M5W300314-Difference-between-LINQ-to-SQL-and-Entity-Framework.html[^]

On Stack Overflow, http://stackoverflow.com/questions/257016/linq-to-sql-vs-entity-framework-performance[^]

Best Method

But a better idea is to always test the code yourself. You can use the Stopwatch class of the .NET framework, (http://msdn.microsoft.com/en-us/library/system.diagnostics.stopwatch(v=vs.110).aspx[^]) and then run both codes, run the EF and also the LINQ code to get the data.

Run them with a loop of 100 times, calculate their time. The code that takes less time will be better one. :-)

Manas Bhardwaj · Answer 3 · 2014-11-02T06:33:00

I personally would go ahead with Entity Framework. There has been much improvement and support for Linq to SQL recently and that is usually one of the sign that Microsoft is not going ahead and investing much in that technology or product.

Having said that look at this article as well:

http://stackoverflow.com/questions/8676/entity-framework-vs-linq-to-sql[^]

Entity Framwork or LINQ for MVC ?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0