Stored Proc vs EF vs NHibernate vs SQLCommands

Using Stored procedure is best way .yes in Professional Projets mostly Stored Procedure will be used.

Its mainy advantages like

1. Write more than one query like Select,Insert Update and etc.
2. 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.
3. Easy to maintain.
4. 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 .
5. Secure as you can pass all the arquments as Objects.
6. Testing is easy.
7. Reusable  write once and use it in many place.