title: How to execute this SQL query using ADO.NET?
body: <p>Given this EXACT ad-hoc query:</p>
  
  <pre><code>DECLARE @list AS TABLE (Name VARCHAR(20))
  INSERT INTO @list(Name)
  VALUES ('Otter', 'Lebron', 'Aaron', 'Brock')
  
  SELECT *
  FROM Users
  WHERE FirstName in (SELECT Name from @list)
  </code></pre>
  
  <p>How can this be done using C# ADO.NET with a SqlParameter?</p>