Well, I don't know about .NET, but I do know how to write a query that does this for you. I bet you can run that query agains your .NET api. So, here we go:
select routine_schema -- database/schema wherein the object resides
, routine_name -- the name of the function/procedure
, routine_type -- PROCEDURE indicates a procedure, FUNCTION indicates a function (duh..)
, routine_definition -- code underlying the sp
, routine_comment -- some human readable comment on the routine
from information_schema.routines
You can add a where to restrict the output to the schema of interest:
where routine_schema = '<schema of interest>'
or the current schema/database
where routine_schema = schema()
see:
http://dev.mysql.com/doc/mysql/en/routines-table.html
for more info