如何从ASP.NET Web API执行(调用)存储过程？

using System.Data;
using System.Data.SqlClient;
using System.Web.Http;

public class ValuesController : ApiController
{
    private string connectionString = "YourConnectionString";

    [HttpGet]
    public IHttpActionResult ExecuteStoredProcedure()
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand("YourStoredProcedureName", connection);
            command.CommandType = CommandType.StoredProcedure;

            // 设置存储过程参数
            command.Parameters.AddWithValue("@Param1", value1);
            command.Parameters.AddWithValue("@Param2", value2);

            connection.Open();

            // 执行存储过程
            command.ExecuteNonQuery();

            // 处理结果
            // ...

            connection.Close();
        }

        return Ok();
    }
}