Isn't this only used to get the DBMS to execute the procedure and return the result back to the application?
I was hoping to do something more like just call the function as a normal C# method but pass in parameters that would be the same as SQL Server 2005 passes in when it calls the procedure.
What I was looking for was more along the lines of (from memory)
[SqlProcedure]
public void foo(...)
{
...
}
public void testfoo()
{
foo(...); // send a varchar(n) to foo
}
I was also hoping to do this in C++ as well, where I have even less of a clue how to do it.