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.