SQL WHERE IN不能与List<string>一起使用

List<string> values = new List<string> { "value1", "value2", "value3" };

// 构建参数化查询
string query = "SELECT * FROM table WHERE column IN ({0})";
string parameterPlaceholder = string.Join(",", values.Select((_, index) => $"@param{index}"));
string parameterNames = string.Join(",", values.Select((_, index) => $"@param{index}"));
string parameterValues = string.Join(",", values.Select((value, index) => $"@param{index} = '{value}'"));

// 执行查询
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand(string.Format(query, parameterPlaceholder), connection))
    {
        for (int i = 0; i < values.Count; i++)
        {
            command.Parameters.AddWithValue($"@param{i}", values[i]);
        }

        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // 处理查询结果
            }
        }
    }
}