如何将"数组"值传递给我的存储过程？

CREATE TYPE dbo.ArrayType AS TABLE (
    Value INT
)

CREATE PROCEDURE dbo.MyStoredProcedure
    @ArrayValues AS dbo.ArrayType READONLY
AS
BEGIN
    -- 在这里处理表值参数
    SELECT * FROM @ArrayValues
END

using (var connection = new SqlConnection(connectionString))
{
    var command = new SqlCommand("dbo.MyStoredProcedure", connection);
    command.CommandType = CommandType.StoredProcedure;

    var arrayValues = new DataTable();
    arrayValues.Columns.Add("Value", typeof(int));

    // 将数组数据添加到DataTable中
    foreach (var value in values)
    {
        arrayValues.Rows.Add(value);
    }

    var parameter = command.Parameters.AddWithValue("@ArrayValues", arrayValues);
    parameter.SqlDbType = SqlDbType.Structured;
    parameter.TypeName = "dbo.ArrayType";

    connection.Open();
    command.ExecuteNonQuery();
}

CREATE PROCEDURE dbo.MyStoredProcedure
    @ArrayValues XML
AS
BEGIN
    DECLARE @xmlHandle INT
    EXEC sp_xml_preparedocument @xmlHandle OUTPUT, @ArrayValues

    SELECT *
    FROM OPENXML(@xmlHandle, '/Array/Value')
    WITH (
        Value INT '.'
    )

    EXEC sp_xml_removedocument @xmlHandle
END

using (var connection = new SqlConnection(connectionString))
{
    var command = new SqlCommand("dbo.MyStoredProcedure", connection);
    command.CommandType = CommandType.StoredProcedure;

    var arrayValues = new XElement("Array", values.Select(value => new XElement("Value", value)));

    var parameter = command.Parameters.AddWithValue("@ArrayValues", arrayValues.ToString());
    parameter.SqlDbType = SqlDbType.Xml;

    connection.Open();
    command.ExecuteNonQuery();
}