我的SQL select查询with condition using list in VB.net

Dim userIds As New List(Of Integer)()
userIds.Add(1)
userIds.Add(2)
userIds.Add(3)

Dim query As String = "SELECT * FROM users WHERE userId IN ({0})"
Dim parameterList As String = String.Join(",", Enumerable.Range(0, userIds.Count).Select(Function(i) $"@p{i}"))
Dim parameterValues As Object() = userIds.Cast(Of Object)().ToArray()

query = String.Format(query, parameterList)

Using connection As New SqlConnection("YourConnectionString")
    Using command As New SqlCommand(query, connection)
        For i As Integer = 0 To parameterValues.Length - 1
            command.Parameters.AddWithValue($"@p{i}", parameterValues(i))
        Next

        connection.Open()
        Dim reader As SqlDataReader = command.ExecuteReader()

        While reader.Read()
            ' 处理查询结果
        End While

        reader.Close()
    End Using
End Using