title: Use Table Valued Parameter (TVP) instead of 'where in'
body: <p>Code like <a href="https://stackoverflow.com/questions/5978728/delete-with-params-in-sqlcommand">this</a>:</p>
  
  <pre class="lang-cs prettyprint-override"><code>connection.Execute("delete from Table where ID in @ids", new { ids=listOfIds });
  </code></pre>
  
  <p>fails when <code>listOfIds</code> is too long. You will get something along those lines:</p>
  
  <pre class="lang-none prettyprint-override"><code>The incoming request has too many parameters. The server supports a maximum of 2100
  </code></pre>
  
  <p>(depending on your rdbms)</p>
  
  <p>Ideally, I would like to use a Table Valued Parameter. I am yet to find a decent dapper example. Could someone please point me in the right direction?</p>