ASP.NET version of "Stored Procs"

If you're using SQL Server for your database and aren't utilizing stored procedures then you're missing out on one of main benefits of using SQL Server in the first place. Stored procedures allow you to prepare queries ahead of time and execute compiled versions of them at run-time. This not only increases performance, it also helps separate web content and presentation-layer code from database-layer code.

Enough convincing you to use stored procs... now on to the how. It's really pretty easy... take a look at the code.

Here's a zip file of the code (1.7 kb)!

Play with the running version.

Back to the "Stored Procs" sample