title: How to pick non-null from a list of columns in LINQ
body: <p>As part of a LINQ query I have a series of columns, only one of which will ever contain a value, how do I assign that single value to a variable without having to do something like</p>
  
  <pre><code>myVal = column1.hasValue ? column1.value : column2.hasValue ? column2.value : column3.hasValue ? column3.value : etc
  </code></pre>
  
  <p>Similar to <a href="https://stackoverflow.com/questions/11620738/how-to-pick-the-non-null-value-from-a-set-of-columns">this question</a> but with LINQ instead of SQL.</p>
  
  <p>Unfortunately, handling anything DB side with SQL isn't an option.</p>