Stored Proc vs EF vs NHibernate vs SQLCommands

Question

1.00/5 (1 vote)

See more:

, +

I've seen a lot of examples for CRUD operations. Most using Stored Procedures.
My doubt is if these examples are using Stored Procedure to make easy get the idea of how to develop a form for CRUD operations or if this is the best practical to use in professional projects. I mean, the most used and best way to do CRUD operations.
That's because I see others ways like:
* Entity Framework
* NHibernate
* Use the query in SQLCommands (DataAdapters, DataTables, ...)

I'd like to hear your opinions!

Posted 31-Aug-15 14:12pm

lpkyrius

Add a Solution

Comments

PIEBALDconsult 31-Aug-15 20:49pm

There's no substitute for getting your hands dirty doing it yourself.
And avoid DataAdapters.

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)

Alexander Siniouguine · Answer 1 · 2015-08-31T20:36:00

Entity Framework is very mature framework and will be your best bet. We use it for very large projects and it works just fine. If your application is simple and you want complete control of what happens, then you can use DataReader for the most optimal performance.

Stored procedures are anti pattern for most of the modern applications as it forces you to move some business logic to a database layer which can quickly become a bottleneck. It was a good approach years ago when overall server performances wasn't that great, not anymore.