C# -如何从sql中捕获多个计数

using System;
using System.Data.SqlClient;

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

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

            string sql = "SELECT COUNT(*) FROM TableName WHERE Condition1; " +
                         "SELECT COUNT(*) FROM TableName WHERE Condition2; " +
                         "SELECT COUNT(*) FROM TableName WHERE Condition3;";

            using (SqlCommand command = new SqlCommand(sql, connection))
            {
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        int count = reader.GetInt32(0);
                        Console.WriteLine("Count: " + count);
                    }

                    reader.NextResult();

                    while (reader.Read())
                    {
                        int count = reader.GetInt32(0);
                        Console.WriteLine("Count: " + count);
                    }

                    reader.NextResult();

                    while (reader.Read())
                    {
                        int count = reader.GetInt32(0);
                        Console.WriteLine("Count: " + count);
                    }
                }
            }
        }
    }
}