SELECT * FROM X WHERE id IN (…) with Dapper ORM

Dapper supports this directly. For example…

string sql = "SELECT * FROM SomeTable WHERE id IN @ids"
var results = conn.Query(sql, new { ids = new[] { 1, 2, 3, 4, 5 }});

unless you are using Postgres, in which case see this answer