title: SQL byte[] Parameters
body: <p>I want to INSERT a byte array into a table (using C#). I've seen this: <a href="http://msdn.microsoft.com/en-us/library/e5xwx8sc%28v=vs.100%29.aspx" rel="nofollow">SqlParameterCollection.Add</a>  but I can't figure out how to use it - it doesn't seem to have a <code>value</code> parameter like <a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparametercollection.addwithvalue%28v=vs.100%29.aspx" rel="nofollow">AddWithValue</a>  does. (Perhaps there's some way to use <code>AddWithValue</code> with byte arrays?)</p>
  
  <p>And the same goes for a SELECT - I want to SELECT a row WHERE ColumnX = MyByteArray. (The column contains <code>binary</code>).</p>
  
  <p>So how is it done?</p>