title: How to concatenate two columns in linq to sql query's select projection
body: <p>1- I use linq to sql to query a database table. 
  <br/>
  2- In my actual table, I store Phone Country Code, Phone Number and Phone Extension in different columns.
  <br/>
  3- When I get the data I need Phone to be equal to concatenation of Phone Country Code, Phone Number and Phone Extension.
  <br/>
  4- For some records, any of these 3 columns might have null values.
  <br/>
  5- If one column is null, then the whole concatenation yields null.</p>
  
  <pre><code>from s in test
  select new{
            Phone = s.PhoneCountryCode + s.PhoneNumber + s.PhoneExtension
  }
  </code></pre>
  
  <p>6- I tried the following, but didn't work. Still yields null.</p>
  
  <pre><code>from s in test
  select new{
            Phone = s.PhoneCountryCode == null ? "" : s.PhoneCountryCode + s.PhoneNumber       == null ? "" : s.PhoneNumber + s.PhoneExtension == null ? "" : s.PhoneExtension
  } 
  </code></pre>