Convert an array of integers for use in a SQL "IN" clause

Question

Surely there is a framework method that given an array of integers, strings etc converts them into a list that can be used in a SQL "IN" clause?

e.g.

int[] values = {1,2,3};

would go to

"(1,2,3)"

Answer 1

var inClause = "("
     + String.Join(",", values.Select(x => x.ToString()).ToArray()) 
     + ")";

Note: You no longer need to call .ToArray() in .NET Framework 4. A new String.Join<T>(string separator, IEnumerable<string> values) method is added.