在C#中从存储过程中检索带有数组对象的模型

using System;
using System.Data;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string storedProcedureName = "YourStoredProcedureName";

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

            SqlCommand command = new SqlCommand(storedProcedureName, connection);
            command.CommandType = CommandType.StoredProcedure;

            // 定义表值参数
            SqlParameter parameter = new SqlParameter();
            parameter.ParameterName = "@ArrayParameter";
            parameter.SqlDbType = SqlDbType.Structured;
            parameter.TypeName = "dbo.ArrayType"; // 替换为实际的表值类型名称
            parameter.Value = GetArrayData(); // 获取数组对象的数据

            command.Parameters.Add(parameter);

            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                // 处理每一行数据
            }

            reader.Close();
        }
    }

    private static DataTable GetArrayData()
    {
        // 创建一个DataTable，用于存储数组对象的数据
        DataTable table = new DataTable();
        table.Columns.Add("Column1", typeof(int));
        table.Columns.Add("Column2", typeof(string));

        // 添加数据到DataTable
        table.Rows.Add(1, "Value1");
        table.Rows.Add(2, "Value2");
        table.Rows.Add(3, "Value3");

        return table;
    }
}