Does storedProcedure always Returns a value

Yes it will return values. And it depends on your execution type like ExecuteReader, ExecuteNonQuery and ExecuteScalar.

If you use ExecuteReader, the Return values are stores as rows and columns. You have to loop through to reader to fetch data.

You can't use ExecuteScalar to get the returned value, and ExecuteNonQuery will always return -1.  To get the value back, you need to add a return value parameter to the command. 

 SqlConnection connection = new SqlConnection(connectionString);
  SqlCommand command = new SqlCommand(storedProcedureName, connection);
   command.CommandType = CommandType.StoredProcedure;
   // Return value as parameter
   SqlParameter returnValue = new SqlParameter("returnVal", SqlDbType.Int);
   returnValue.Direction = ParameterDirection.ReturnValue;  
   command.Parameters.Add(returnValue);
    // Execute the stored procedure
   connection.Open();
   command.ExecuteNonQuery(); // Return value will be stored in returnValue 
   connection.Close();
 
-----------------------------------------------------------------------------------------
If this post helps you, then mark as "Correct Answer"
Thank You