如何从数据库(C#)的数组中删除数据？

using System;
using System.Data.SqlClient;

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

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

            // 构建删除语句
            string deleteQuery = "DELETE FROM YourTable WHERE Id IN (@Ids)";

            // 创建命令对象
            using (SqlCommand command = new SqlCommand(deleteQuery, connection))
            {
                // 设置参数
                int[] idsToDelete = { 1, 2, 3 }; // 替换为要删除的数据的实际ID数组
                command.Parameters.AddWithValue("@Ids", idsToDelete);

                // 执行删除操作
                int rowsAffected = command.ExecuteNonQuery();

                Console.WriteLine("删除了 {0} 行数据。", rowsAffected);
            }
        }
    }
}