title: IF statement inside a LINQ SELECT
body: <p>I'm trying to produce an IF conditional statement inside of a "select new" that checks the values of two fields in order to fill a property.</p>
  
  <pre><code>from e in Employees
  where e.EmployeeID == id
  select new {
      EmployeeID = e.EmployeeID,
      EmployeeName = e.FirstName + " " + e.LastName,
      Status = (if e.col1.HasValue then "This Value" else if e.col2.HasValue then "Other Value")
  }
  </code></pre>
  
  <p>The columns are nullable and therefore the column types are DateTime? data types.</p>
  
  <p>Only one or the other column will have a datetime value, not both.</p>
  
  <p>How do I go about doing this???</p>