Stored Proc vs EF vs NHibernate vs SQLCommands

Question

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!

Syed Shanu · Answer

Using Stored procedure is best way .yes in Professional Projets mostly Stored Procedure will be used. Its mainy advantages like Write more than one query like SelectInsert Update and etc. For future update.If you have any minor changes in your query No need to change in your Program.just do the changes in Stored Procedure. Easy to maintain. Speed as you can do more then one Select query and return to your program this will avoid many hit to database.for example you have to perform 3 sql select query in one operations .In SP you can write all 3 query and execute this will avoid more hits to DB . Secure as you can pass all the arquments as Objects. Testing is easy. Reusable write once and use it in many place.