使用 Group By 时计算 Access Linq 中位数的最佳方法

using System;
using System.Linq;
using System.Data.OleDb;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\your\\database.accdb;Persist Security Info=False;";

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

            var query = "SELECT column_name FROM table_name";

            using (OleDbCommand command = new OleDbCommand(query, connection))
            {
                using (OleDbDataReader reader = command.ExecuteReader())
                {
                    var data = new List<double>();

                    while (reader.Read())
                    {
                        data.Add(reader.GetDouble(0));
                    }

                    double median = CalculateMedian(data);

                    Console.WriteLine("Median: " + median);
                }
            }
        }
    }

    static double CalculateMedian(List<double> data)
    {
        int count = data.Count;
        int middle = count / 2;

        var sortedData = data.OrderBy(n => n).ToList();

        if (count % 2 == 0)
        {
            return (sortedData[middle - 1] + sortedData[middle]) / 2;
        }
        else
        {
            return sortedData[middle];
        }
    }
}