title: Creating Generic MySQL SELECT Statement in C#
body: <p>There are a few similar questions, but none of them seem to answer my problem.
  In my application I use lots of different SELECT queries and I don't want to write a method for every one, so I'm trying to create a generic one that I can just pass the specific parameters in.
  This is the specific example that I'm trying to modify:
  <a href="https://i.stack.imgur.com/C9kMn.png" rel="nofollow noreferrer">SELECT Statement</a>
  This is my attempt at generalising it:
  <a href="https://i.stack.imgur.com/sB3k6.png" rel="nofollow noreferrer">Generic SELECT Statement</a>
  I have considered trying to split up columns string by the comma delimiter, using list or arrays, but I can't work out how to solve this issue. The specific bit that I want help with is the line with the error ("cannot convert from 'System.Collections.Generic.List' to 'int'"), but I don't know enough about data readers to fix it...</p>
  
  <p>Any help would be greatly appreciated.</p>