title: SELECT * FROM X WHERE id IN (...) with Dapper ORM
body: <p>What is the best way to write a query with IN clause using Dapper ORM when the list of values for the IN clause is coming from business logic? For example let's say I have a query:</p>
  
  
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * 
    FROM SomeTable 
   WHERE id IN (commaSeparatedListOfIDs)
  </code></pre>
  
  <p>The <code>commaSeparatedListOfIDs</code> is being passed in from business logic and it can be any type of <code>IEnumerable(of Integer)</code>. How would I construct a query in this case? Do I have to do what I've been doing so far which is basically string concatenation or is there some sort of advanced parameter mapping technique that I'm not aware of?</p>