Ado.net or entity framework in MVC 5. Which one better ?

Question

1.00/5 (1 vote)

See more:

Previous I was working on the Asp.Net(C#) with the ADO.Net Web Application, Now i want move on MVC 5. I am totally new in the MVC.

I want to know which one is better in MVC 5, that ADO.Net or Entity Framework ?

What I have tried:

I have not perform any project with the use of MVC architecture.

Posted 12-Apr-16 20:39pm

Amit-kumar-Amit-Kumar

Updated 15-Apr-16 9:15am

Add a Solution

1 solution

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)

Richard Deeming · Answer 1 · 2016-04-15T09:15:00

Solution 1

Which is better: a speedboat, or a Ferrari? ^*

Without knowing the intricate details of your project, or your team's experience, capabilities and preferences, there's no way we can tell you which technology is "better".

They're both pretty good, and both perfectly usable in ASP.NET MVC. You'll tend to see more examples using EF than raw ADO.NET, but EF has some drawbacks and limitations. ADO.NET has been pretty stable for the last 15 years, whereas EF has gone through several major shifts in its lifetime.

There are also other ORMs to consider, such as NHibernate[^]; or you might want a "micro-ORM" like Dapper[^].

^* And the answer is "a hovercraft". But preferably not one that's full of eels. :)

Posted 15-Apr-16 9:15am

Richard Deeming

Comments

#realJSOP 4-Feb-19 8:10am

I know this is almost 3 years old, but...

We have an existing ASP.Net/Javascript/Ajax site that uses ADO, and they're converting it to EF. I am not on board with this because EF has a huge footprint, and 99% of our database access is via stored procs, thus nullifying most benefits that EF provides. Virtually ALL of our stored procs use at least one join of some kind, and there are a lot of CTEs. I see no tangible/useful justification for the switch. I'm in the process of designing a new version of the site with MVC5 and the template insists on adding EF when I select some form of user account. I haven't yet investigated removing EF. IMHO, the juice ain't worth the squeeze.

Richard Deeming 4-Feb-19 8:22am

Indeed - if you're mostly using stored procedures, EF is a waste of time.

The user accounts are probably using ASP.NET Identity, which uses EF by default. You can get rid of it, but you'll need to write some code. For example:
Exorcising Entity Framework from ASP.NET Identity – Mark Johnson[^] (MVC5)
ASP.NET Core Identity Without Entity Framework – Mark Johnson[^] (.NET Core)

#realJSOP 4-Feb-19 8:46am

Yeah, I found those links this morning, but they're blocked at work. :/

As an aside, I explored core razor pages, and there's too much dancing around with IIS to make it worth our while. Our app is currently a hyper-delicate house of cards, and converting to core AND mucking around in IIS seems fraught with more danger than I want to personally deal with. Besides, CRaP is still in its infancy, and there's very little in terms of tangible help/examples on the internet right now. However, I do prefer the CRap folder hierarchy to the old MVC5 arrangement.

Richard Deeming 4-Feb-19 8:48am

Can you get to GitHub? Mark posted a demo of the MVC5 one there:
https://github.com/mark-j/DapperIdentityDemo[^]

#realJSOP 4-Feb-19 8:51am

I don't want to use an ORM of any kind. Isn't that what Dapper is?

Richard Deeming 4-Feb-19 8:55am

It's more of an object mapper. It materializes POCOs from raw ADO.NET queries, but it doesn't add any change tracking or other overheads.

#realJSOP 4-Feb-19 10:31am

I'll look at that, then.

Richard Deeming 4-Feb-19 10:33am

Even if you don't want to use Dapper, it should be fairly simple to change Mark's code to use raw ADO.NET instead. Certainly a lot simpler than trying to unpick the equivalent EF code. :)