Question List parameters support?

[coolblabla]

Hi, awesome work! does nvivo dbhelps support this like following ? "select * from (select 1 as Id union all select 2 union all select 3) as X where Id in @Ids",

[coolblabla]

and do I have to use var transaction = connection.BeginTransaction(); instead of connection?

using (var connection = db.CreateConnection()) {
    connection.Open();
    db.ExecuteNonQuery(..., connection);
    db.ExecuteNonQuery(..., connection);
    db.ExecuteNonQuery(..., connection);
    return db.ExecuteScalar<int>(..., connection);
}