title: How to fetch 3 column values together from a table
body: <p>I have a table named CrewMembers which have 3 columns-FirstName,MiddleName and LastName.
  I want to fetch the values of these 3 columns together using entity framework in a combobox in this format-</p>
  
  <p>LastName,FirstName MiddleName</p>
  
  <p>Here is the code for the same-</p>
  
  <pre><code>     public IEnumerable GetCrewMember()
       {
          SASEntities db = DataContextFactory.GetSASEntitiesDataContext();
           return (from cm in db.CrewMember
                 select
                   cm.LastName + "," +
                    cm.FirstName +" "+
                    cm.FullName
             ).ToList();
         }
  </code></pre>
  
  <p>Now when I execute the code,I get only those names in the combobox which have all three values in the table but my MiddleName column can be left Null.Hence,I am not getting full names of those records which doesn't have a MiddleName.</p>
  
  <p>How can I resolve this issue?</p>