ExecuteScalar和ExecuteNonQuery冲突

using System;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "SELECT COUNT(*) FROM Customers";

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

            // 使用ExecuteScalar执行查询并返回结果
            SqlCommand command = new SqlCommand(query, connection);
            int count = (int)command.ExecuteScalar();
            Console.WriteLine("Total number of customers: " + count);

            // 使用ExecuteNonQuery执行更新操作
            string updateQuery = "UPDATE Customers SET City = 'New York' WHERE Country = 'USA'";
            SqlCommand updateCommand = new SqlCommand(updateQuery, connection);
            int rowsAffected = updateCommand.ExecuteNonQuery();
            Console.WriteLine("Rows affected: " + rowsAffected);
        }
    }
}