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

main.cs
using System.Data.SqlClient;

// Create connection string
var connectionString = "Your connection string";

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();

    using (var command = new SqlCommand("YourStoredProcedureName", connection))
    {
        // Set command type to stored procedure
        command.CommandType = CommandType.StoredProcedure;

        // Add input parameter
        var firstNameParam = new SqlParameter("@FirstName", SqlDbType.VarChar, 50);
        firstNameParam.Value = "John"; // Replace with actual first name
        command.Parameters.Add(firstNameParam);

        // Add output parameter
        var lastNameParam = new SqlParameter("@LastName", SqlDbType.VarChar, 50);
        lastNameParam.Direction = ParameterDirection.Output;
        command.Parameters.Add(lastNameParam);

        // Execute the stored procedure
        command.ExecuteNonQuery();

        // Concatenate first name and last name to get full name
        var fullName = firstNameParam.Value.ToString() + " " + lastNameParam.Value.ToString();
    }
}
1093 chars
32 lines