将C# SQL Server数据转换为长数组

using System;
using System.Collections.Generic;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;User ID=YourUsername;Password=YourPassword";
        string query = "SELECT YourColumnName FROM YourTableName";

        List<long> longArray = new List<long>();

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

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    long value = Convert.ToInt64(reader["YourColumnName"]);
                    longArray.Add(value);
                }

                reader.Close();
            }

            connection.Close();
        }

        long[] resultArray = longArray.ToArray();

        // 使用 resultArray 进行后续操作
    }
}