title: EntityDataSource concatenate two fields
body: <p>I have EDSC and I try to concatenate two columns in a select statement. I try something like this:</p>
  
  <pre><code>&lt;asp:EntityDataSource ID="srcData" runat="server" ConnectionString="name=edm"
  DefaultContainerName="edm" EnableFlattening="False" EntitySetName="Staff"
  Select="it.[StaffID], NewName = it.[Staff_Name] + it.[Staff_Surname]" Where="it.Retired=False"&gt;
  </code></pre>
  
  <p>Is there any way to do something like this: NewName = it.[Staff_Name] + it.[Staff_Surname]</p>