Stored Procedures tutorial article

A complete tutorial on how to use the StoredProcedure class in the SixPack library is now available on CodeProject: SixPack Library.

Why did we develop stored procedures support?

Stored procedure invocation is a very common activity in most enterprise or web development projects. Microsoft's ADO.NET technology makes it very simple to do, so why go through the hassle of using a library to do it?

Here are some reasons of why we implemented this feature of the library:

• Even though it's powerful, ADO.NET is lacking a few features that you will likely need to develop when supporting large sites (for example, handling deadlocks).
• As a best practice, a lot of people do not want developers to use all features of ADO.NET (typically, the DataReaders need to be handled very carefully).
• We wanted the stored procedure invocation code to be database independent.
• You have a large number of stored procedures to support and we want the developer to be able to generate the invocation code, instead of writing it.
• We want to be able to easily trace stored procedure performance during development, while not having a performance bottleneck at release.

Read the full article, including source code, here: CodeProject: SixPack Library -- StoredProcedure

About the SixPack library
The SixPack rapid development library is a collection of classes for rapid development on the .NET/Mono platform. It is released under the Limited General Public License 2.1 (LGPL) and is available through Google Code.
http://code.google.com/p/sixpack-library/