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!