How to: Execute a Stored Procedure using EnterPriseLibrary that Returns a Value?

var selectCommand = DatabaseInstance.GetStoredProcCommand("GetReturnValue");



selectCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@anyname", DbType.Int16));

selectCommand.Parameters["anyname"].Direction = ParameterDirection.ReturnValue;



DatabaseInstance.ExecuteNonQuery(selectCommand);



var intReturnValue = Convert.ToInt64(selectCommand.Parameters["@ReturnValue"].Value);

var selectCommand = DatabaseInstance.GetStoredProcCommand("GetReturnValue");

DatabaseInstance.AddParameter(selectCommand, "anyname", DbType.Int32, ParameterDirection.ReturnValue, null, DataRowVersion.Default, null);



DatabaseInstance.ExecuteNonQuery(selectCommand);



var returnValue = Convert.ToInt32(DatabaseInstance.GetParameterValue(selectCommand, "anyname"));