title: Having multiple values assigned to a single ADO.Net SqlClient parameter
body: <p>I wish to run an SQL select statement similar to this</p>
  
  <pre><code>SELECT * FROM CatalogueItems WHERE id IN (1,10,15,20);
  </code></pre>
  
  <p>using ADO.Net SqlClient style @name parameters. I've tried using a stored SQL strings</p>
  
  <pre><code>SELECT * FROM CatalogueItems WHERE id IN (@Ids)
  </code></pre>
  
  <p>and then in my C# code</p>
  
  <pre><code>SqliteCommand command;
  //...
  //returns 0 results
  command.Parameters.Add("@Ids", null).Value = "1,10,15,20";
  
  //returns 0 results
  command.Parameters.Add("@Ids", DbType.String).Value = "1,10,15,20";
  
  //returns 1 or more results
  command.Parameters.Add("@Ids", null).Value = "1";
  </code></pre>
  
  <p>returns an empty result set, yet the individual string parameters return results. </p>
  
  <p>Is this query support? Is there another DBType I should be using?</p>
  
  <p>Thanks.</p>