title: Access column name with ExecuteScalar in C#?
body: <p>I have a stored procedure that returns 0 or 1 depending on certain outcomes. I often execute this procedure manually, so to have a description of the success/failure that's easily viewed in SSMS but still readable as 0/1 in code, I select the 0 or 1 as a different column name, i.e. <code>SELECT 0 AS ThisReason</code> or <code>SELECT 0 AS ThatReason</code>.</p>
  
  <p>There is almost certainly a better way to handle this, but it got me curious - is it possible to read the name of the column you've selected when using ExecuteScalar in C#?</p>