title: Asymmetric decryption through LINQ
body: <p>I've got a column in a table that has been asymmetrically encrypted through a SQL trigger. The key (by password) resides in the SQL DB. Now, I need to decrypt it through a console app running every xx minutes.</p>
  
  <p>I'm grabbing all the fields through LINQ and running a foreach loop and generating some text files and xml files and so forth. The issue arises when I try to decrypt the data.</p>
  
  <p>So, I've got a few options, but none are getting me anywhere.</p>
  
  <ul>
  <li><p>I've tried to run an ExecuteCommand, but I haven't been able to resolve how to open the asymmetric key in the first place.</p></li>
  <li><p>I've tried running a stored procedure, then calling it through LINQ. But can I loop through the results in order to match them (i.e., should I be running a foreach inside of the foreach)?</p></li>
  <li><p>I've tried 12 different other things, to no avail. :)</p></li>
  </ul>
  
  <p>Anyway, any thoughts would be much appreciated. I just need to grab the unencrypted values (I'm able to decrypt them just fine in MSSQL) and add them to my workflow.</p>