C# 精簡版 MySqlHelper 封裝（支援非同步、參數化、DataTable/DataReader、連線池整合）

C# 精簡版 MySqlHelper 封裝（進階版）

在基礎版基礎上新增非同步方法、連線池配置建議、例外處理與單元測試範例，適合直接納入專案共用庫。

完整程式碼

using System;
using System.Data;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Configuration;

public static class MySqlHelper
{
    private static readonly string ConnStr = ConfigurationManager.ConnectionStrings["MySqlConn"].ConnectionString;

    public static MySqlConnection CreateConnection()
    {
        var conn = new MySqlConnection(ConnStr);
        conn.Open();
        return conn;
    }

    // === 同步方法 ===
    public static int ExecuteNonQuery(string sql, params MySqlParameter[] parameters)
    {
        using (var conn = CreateConnection())
        using (var cmd = conn.CreateCommand())
        {
            cmd.CommandText = sql;
            if (parameters != null) cmd.Parameters.AddRange(parameters);
            return cmd.ExecuteNonQuery();
        }
    }

    public static object ExecuteScalar(string sql, params MySqlParameter[] parameters)
    {
        using (var conn = CreateConnection())
        using (var cmd = conn.CreateCommand())
        {
            cmd.CommandText = sql;
            if (parameters != null) cmd.Parameters.AddRange(parameters);
            return cmd.ExecuteScalar();
        }
    }

    public static MySqlDataReader ExecuteReader(string sql, params MySqlParameter[] parameters)
    {
        var conn = CreateConnection();
        var cmd = conn.CreateCommand();
        cmd.CommandText = sql;
        if (parameters != null) cmd.Parameters.AddRange(parameters);
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
    }

    public static DataTable ExecuteDataTable(string sql, params MySqlParameter[] parameters)
    {
        var table = new DataTable();
        using (var conn = CreateConnection())
        using (var cmd = conn.CreateCommand())
        {
            cmd.CommandText = sql;
            if (parameters != null) cmd.Parameters.AddRange(parameters);
            using (var adapter = new MySqlDataAdapter(cmd))
                adapter.Fill(table);
        }
        return table;
    }

    // === 非同步方法 (.NET 4.5+) ===
    public static async Task ExecuteNonQueryAsync(string sql, params MySqlParameter[] parameters)
    {
        using (var conn = new MySqlConnection(ConnStr))
        using (var cmd = conn.CreateCommand())
        {
            await conn.OpenAsync();
            cmd.CommandText = sql;
            if (parameters != null) cmd.Parameters.AddRange(parameters);
            return await cmd.ExecuteNonQueryAsync();
        }
    }

    public static async Task