如何使用c#从数据库中读取数组字段？

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串

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

            string query = "SELECT ArrayField FROM YourTable"; // 替换为实际的表和字段名称

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // 读取数组字段
                        string[] arrayField = (string[])reader["ArrayField"];

                        // 处理数组数据
                        foreach (string item in arrayField)
                        {
                            Console.WriteLine(item);
                        }
                    }
                }
            }
        }
    }
}