The best replacement for stored procedures is functions.

The best alternatives to stored procedures are rated as following:
★★★★★  functions
★★★★  views
★★★★  dynamic sql
★★  triggers
★★  linq
★★  inline sql
★★  entity framework
★★  orm
★  web services
★  ad-hoc sql
★  prepared statements
★  queries
  dynamic queries
  linq to entities
  parameterized queries
  raw queries
  embedded sql
  user defined functions
  direct sql
  inline queries
  sql queries
  functions sql
  sql functions

Your alternative for stored procedures is not listed? Suggest!
Speaking about stored procedures, one probably shouldn't forget about parameters.

Other search terms related to stored procedures and their ratings are:
★★★★★ parameters
★★★★ output parameters
★★ entity framework
★ conditional statements in sql
★ linq
★ ado
★ linq to sql
You have in mind a companion for stored procedures and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of stored procedures in all years. Click on graph for more.
stored procedures
functions
views