Stored Procedure Invocation Code Generator for VB, C# and JScript.NET:

A great tool that can cut development time multifold, by creating the a sample xml document and defining the name of the stored procedure and its parameters, then assiciate the XML to the custom tool (as part of the install), it will automatically generate the code to call the stored procedure as though it was a class. Download the software and code here

The only disadvantage i have found(dont claim that ive read the entire document /source code to check for bypass) is that we have to specify the DB server name in the XML document. So once we move to a staging server or deployment server then we will have to modify the server name again. I guess you can overcome the limitation by modifying the source code.

All in all *great tool*, will post additional details once i try out the software, can save your project loads of time.