stored-procedures code snippets in csharp

call a stored procedure where the input is a first name and the output is a last name, the return the full name in csharp