title: Add list of IDs as parameter for Firebird query in C#
body: <p>I would like to update a list of rows given by a list of IDs. Normally, the parameters of the query can be passed via the parameter property. But if I pass a list of IDs, Firebird will not accept the query. I'm using the FirebirdSql.Data.FirebirdClient from NuGet.</p>
  <p>Code (simplified):</p>
  <pre class="lang-csharp prettyprint-override"><code>List&lt;string&gt; ids = someList.Select(_ =&gt; _.Id).ToList();
  using (var fbCommand = new FbCommand(&quot;UPDATE someTable SET NAME='foo' WHERE ID IN (@ids)&quot;, fbConnection))
  {
      fbCommand.Parameters.Add(&quot;ids&quot;, ids);
      fbCommand.ExecuteNonQuery();
  }
  </code></pre>
  <p>The Table &quot;someTable&quot; is defined like this:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE someTable (
      ID CHAR(36),
      NAME CHAR(20)
  );
  </code></pre>
  <p>This is the exception:</p>
  <blockquote>
  <p>Exception thrown: 'FirebirdSql.Data.FirebirdClient.FbException' in FirebirdSql.Data.FirebirdClient.dll
  An exception of type 'FirebirdSql.Data.FirebirdClient.FbException' occurred in &gt;FirebirdSql.Data.FirebirdClient.dll but was not handled in user code
  arithmetic exception, numeric overflow, or string truncation
  string right truncation</p>
  </blockquote>