title: How can I pass array as a sql query param for cosmos DB query
body: <p>I want to pass array as a param to SqlQuerySpec to be able to use it in the IN expression when building query for azure cosmos db.
  What i'm trying to do is something like we do with regular (string, int etc) params:</p>
  
  <pre><code>private SqlQuerySpec BuildQuery(IEnumerable&lt;string&gt; exclTypes)
  {
      var queryText = "SELECT * FROM root r WHERE r.Type NOT IN (@types)";
      var parameters = new SqlParameterCollection{new SqlParameter("@types", exclTypes.ToArray())};
      return new SqlQuerySpec()
      {QueryText = queryText, Parameters = parameters};
  }
  </code></pre>
  
  <p>But that doesn't work in such way. Any other ways I can pass array as a param?
  Thanks.</p>