Programmatically Retrieving a Stored Procedure’s Parameters
Stored procedures in SQL Server are similar to methods in C# and Visual Basic code. They encapsulate one or more statements into a single, parameterized construct. Both stored procedures and methods are a form of code reuse and their use help developers adhere to the DRY principle ( D on’t R epeat Y ourself). But the similarities don’t end there. The .NET Framework has a feature called Reflection that enables developers to programmatically retrieve a list of methods for a given class, along with their input parameters and return types. It’s also possible to programmatically determine what stored procedures exist in a database, along with each stored procedure’s input and output parameters.
